System and method for allocating, scheduling, tracking and reporting usage of training assets and facilities

ABSTRACT

A system and method for scheduling, managing and reporting usage of two or more training facilities by two or more grade levels xl of instruction with two or more classifications of instruction defining typical student experience and hours including user defined multi-criteria queries, using a computer and a spreadsheet with single cell data entry and specified formulas to generate particular scheduling, tracking and reporting of facilities scheduled and educational hours&#39; completed with infinite levels of classification.

CROSS-REFERENCE TO RELATED APPLICATIONS

This patent application claims priority to, and incorporates byreference, U.S. Provisional Patent Application Ser. No. 61/456,688 filed10 Nov. 2010.

BACKGROUND OF THE INVENTION

1. Field of the Invention

The invention is a system and method for spreadsheet and specificformula based governance of training assets and facilities, includingstudent achievements, in any field and particularly in the medicalsimulation training field.

2. Description of Related Art

As powerful as sophisticated databases can be, in many cases they arenot user friendly except in the eyes of formally trained informationtechnology personnel. At the same time, the use of a spreadsheet (evenby formally trained information technology personnel) for tracking andreporting of data records of any complexity is usually problematic: thefunctions of spreadsheets are not generally intended or believed to beparticularly suited for management of data records including scheduling,tracking and reporting in multiple dimensions (such as multiple trainingfacilities for multiple grade level users). Nonetheless, for managementof training assets and facilities, given the choice many managers wouldprefer a spreadsheet-based system, if it existed, to having to masterand use one of the comprehensive database programs available at thiswriting.

The need for easy-to-use tracking and reporting systems is particularlyacute in any field where highly prized, high-demand training assets andfacilities are used. As a nonlimiting example, nursing studentsgenerally are required to complete various simulations in simulationlaboratories. These highly specialized simulation facilities are in noway fungible, so scheduling, tracking and reporting usage are bothcritically important and, up until the present invention, unwieldy toimplement. In order to understand the first embodiment of the presentinvention, therefore, an initial review of the state of the art ofnursing simulation laboratory facilities is helpful.

Studies show that students learn certain nursing procedures or healthcare interventions as well or better, in a simulated environment, asthey do in a clinical setting. Simulation laboratory education providesin-depth preparation for clinical experience, because simulation effectsboth protocol development and practice before the student everencounters any patient on which the same procedure is to be performed. Alist of simulation equipment could include without limitation medicalmannequins and simulators such as those having the intuitivelydescriptive names of: SimMan; SimMan 3G; SimBaby; Pelvic Simulator;NOELLE® Birthing Simulator including Newborn HAL (both remotecontrollable from up to 100 meters; standard features includeprogrammable hemorrhage using simulated blood and catheterization withflow of simulated urine); Nurse Ann Vital Sims 3; Vital Sim Child; VitalSim Infant. Other simulator mannequins known at this writing includeresuscitation mannequins in which cardiac arrest simulation(particularly for EMT or paramedic training) includes reflux orregurgitation of artificial vomitus, which vomitus material must becleared as part of reestablishing a reliable airway for successfulcardiopulmonary resuscitation. Users of medical training simulators areinevitably positive if not grateful for the opportunity to practice on asimulator prior to treating a living patient experiencing the same orsimilar symptoms or crises.

Not only because practitioners require space around each mannequin orsimulator in order to use it but because, in order to simulate aclinical setting, each mannequin or simulator will generally be in itsown cubicle or patient room to enhance the simulation, such mannequin orsimulator resources are generally allocated one-to-a-room orone-to-a-simulation-laboratory. (If all mannequins and simulators areused at once in one room, for instance in a disaster drill, the advancescheduled unavailability of all the mannequins and simulators still hasto be scheduled and tracked.) Due to their high expense and high demand,simulators and their respective laboratories clearly constitute scarceresources for which scheduling, tracking and reporting has traditionallybeen a constant challenge. The simulator laboratories certainly cannotbe “double-booked,” but it is important that they be completelyscheduled at all available times both for optimal medical education ofthe enrolled students and to maximize the economic return to theeducational institution of the significant investment in the simulatorresources themselves. In addition, and particularly in a medicaleducational setting, there is also a need not only to manage thescheduling and management of multiple simulation facilities but also totrack student hours' completed as a condition of curriculum fulfillmentand/or student licensure. A need therefore remains for a user-friendlyspreadsheet-based system for allocating, scheduling, tracking andreporting assets and facilities, medical or otherwise, in a way thatcoordinates both facilities management and student grade level andhours' completion in an easy to use system and method of managing andreporting using (only) a computer spreadsheet.

SUMMARY OF THE INVENTION

The present invention is a system and method for scheduling, managingand reporting usage of two or more training facilities by two or moregrade levels xl of instruction with two or more classifications ofinstruction defining typical student experience and hours including userdefined multi-criteria queries, which includes a number of stepsdescribed as follows. First, the user enters data into a spreadsheet ona computer and specifically enters the data on a “Summary” sheet usingsingle-cell, multiple-criteria data entry, following on-screeninstructions described below. Additional classifications include, butare not limited to, typical student experience by grade level, typicalstudent simulation or non-simulation experience by grade level, or anyclassification defined by the data user. Student level “xl” is specifiedas to individual student levels tracked by the spreadsheet, where “xl”is a level variable and actual data input specifies grade level by code.After data entry, single-cell student level classification, simulationexperience classification, typical student level simulation andnon-simulation experiences, and user defined filtered retrieval andtotaling on dedicated tally sheets is implemented using formulas in oneof two approaches. In the first approach, the formulas are:

-   -   For Tally Sheet formula        =IF(ISNUMBER(FIND(“xl-”,Summary!$J10)),MID(Summary!$J10,3,3),0),        and formula =IF(U5=FALSE,VALUE(0),VALUE(U5));    -   For Tally SIM formula        =IF(ISNUMBER((FIND(“xl-”,Summary!$C158))*(FIND(“SIM”,Summary!$C158))),MID(Summary!$C158,3,3),0),        and formula =IF(C107=FALSE,VALUE(0),VALUE(C107));    -   For Tally Stdnt formula        =IF(ISNUMBER((FIND(“xl-”,Summary!$C158))*(FIND(“Stdnt”,Summary!$C158))),MID(Summary!$C158,10,3),0),        and formula =IF(C152=FALSE,VALUE(0),VALUE(C152));    -   For Tally Stdnt SIM formula        =IF(ISNUMBER((FIND(“xl-”,Summary!$C11))*(FIND(“SIM”,Summary!$C11))*(FIND(“Stdnt”,Summary!$C11))),MID(Summary!$C11,10,3),0),        and =IF(C5=FALSE,VALUE(0),VALUE(C5));    -   For Tally Open Query formula        =IF(ISNUMBER((FIND(Summary!$C$9,Summary!$C11))*(FIND(Summary!$D$9,Summary!$C11))*(FIND(Summary!$E$9,Summary!$C11))*(FIND(Summary!$F$9,Summary!$C11))*(FIND(Summary!$G$9,Summary!$C11))*(FIND(Summary!$H$9,Summary!$C11))),MID(Summary!$C11,3,3),0),        and formula =IF(C5=FALSE,VALUE(0),VALUE(C5)).

As to the first set of formulas presented above, automatically summedtotals by room, student level, simulation and non-simulationclassification, typical student experience by student level, typicalstudent simulation experience by level, infinite classification asdefined by user with multi-criteria queries, etc. are obtained on theSummary Sheet utilizing formulas =Tally!$C178&″Hrs:″&Tally!$J178, and=SUM(Tally!K5:K175,Tally!Y5:Y175,Tally!AM5:AM175,Tally!BA5:BA175,Tally!BO5:BO175,Tally!CC5:CC175,Tally!CQ5:CQ175,Tally!DE5:DE175,Tally!DS5:DS175).Next, automatically summed totals by student level, simulation andnon-simulation classification, typical student experience by studentlevel, typical student simulation experience by level infiniteclassification as defined by user with multi-criteria queries, etc. arederived on individualized student level and open query sheets utilizingformula=SUM(Tally!K5:K175,Tally!Y5:Y175,Tally!AM5:AM175,Tally!BA5:BA175,Tally!BO5:BO175,Tally!CC5:CC175,Tally!CQ5:CQ175,Tally!DE5:DE175,Tally!DS5:DS175).Finally, by copying the structure of the Summary Sheet to the studentlevel sheets by formula, =(Summary!A10), when the Summary sheet isupdated all related sheets are updated.

Although the above describes the possibility of stepwise implementation,the steps can be changed in order or can all be performed simultaneouslyafter initial data entry, according to the functioning of the databasecontaining the formulas.

In a second embodiment of the invention, a more elaborate array offormulas are populated into the spreadsheet to accomplish the samegeneral goal of data entry and automated computer processing offacilities scheduling information in a spreadsheet, in which thefacilities scheduling requires tracking of hours scheduled as well astracking and reporting of two or more user grade levels xl, at least oneuser experience xe, and at least one user experience subset xs, thelatter of which is usually but not necessarily a “SIM” experience, thatis, a simulation experience as a subset of total student experience. Thereason “student experience” is important is that when classes arescheduled into a facility and there are multiple students in a class,hands-on laboratory or simulation experience for that student may wellbe for a shorter time than the class is scheduled into the facility.When a class is scheduled to use a particularly laboratory or otherfacility, then, “student experience” or a typical subset “studentsimulation experience” can track usage for each individual student, notjust the class as a whole. The overview of the second embodiment of theinvention is to implement entry and capture of all the quantitativescheduling data together with optional and potentially unpredictabletext strings that may accompany complex facilities' scheduling dataentry. The aforementioned capture means that hours scheduled, user gradelevels, student experience, and student experience subset, etc., aretracked along with additional optional data, by entering data in asingle entry location, such that the data may be filtered, summed andcounted and the entire data event is summarized automatically in varioussingle cells. In this way, by single data entry of scheduling data, alloutput data is available in customized cells as outputs to a user, asdescribed herein, by operation of the formulas in the spreadsheet.

BRIEF DESCRIPTION OF THE DRAWING(S)

The patent or application file contains at least one drawing executed incolor. Copies of this patent or patent application publication withcolor drawing(s) will be provided by the Office upon request and paymentof the necessary fee.

FIG. 1 is a screen shot of the “Summary” sheet layout for the nursingeducation simulation lab management first embodiment of the presentinvention;

FIG. 2 is a screen shot of the “Tally” sheet layout for the nursingsimulation education first embodiment of the present invention;

FIG. 3 is a screen shot of the “Freshman” sheet layout for the nursingeducation simulation lab management first embodiment of the presentinvention;

FIG. 4 is a screen shot of the “Sophomore” sheet layout for the nursingeducation simulation lab management first embodiment of the presentinvention;

FIG. 5 is a screen shot of the “Second Degree” sheet layout for thenursing education simulation lab management first embodiment of thepresent invention;

FIG. 6 is a screen shot of the “Open Query” sheet layout for the nursingeducation lab management first embodiment of the present invention;

FIG. 7 is a screen shot of the “Labs 550-551” sheet layout for thenursing education simulation lab management first embodiment of thepresent invention;

FIG. 8 is screen shot of the “Summary” sheet layout for the nursingeducation simulation lab management second embodiment of the presentinvention;

FIG. 9 is a screen shot of the “Freshman” sheet layout for the nursingeducation simulation lab management second embodiment of the presentinvention;

FIG. 10 is a screen shot of the “Second Degree” sheet layout for thenursing education simulation lab management second embodiment of thepresent invention;

FIG. 11 is a screen shot of the “Open Query” sheet layout for thenursing education simulation lab management second embodiment of thepresent invention;

FIG. 12 is a screen shot of the “Labs 550-551” sheet layout for thenursing education simulation lab management second embodiment of thepresent invention;

FIG. 13 is the first of three screen shots of the “Tally” sheet layoutfor the nursing education simulation lab management second embodiment ofthe present invention;

FIG. 14 is the second of three screen shots of the “Tally” sheet layoutfor the nursing education simulation lab management second embodiment ofthe present invention;

FIG. 15 is the third of three screen shots of the “Tally” sheet layoutfor the nursing education simulation lab management second embodiment ofthe present invention;

FIG. 16 is a screen shot of the “Selected Period” sheet layout for thenursing education simulation lab management second embodiment of thepresent invention; and

FIG. 17 is a screen shot of the “Customize” sheet layout for the nursingeducation simulation lab management second embodiment of the presentinvention.

DETAILED DESCRIPTION OF THE INVENTION

The present system and method invokes a specialized application of anExcel (or similar) computer spreadsheet program to function as adatabase manager of resources, typically medical resources, personnel,facilities, student schedules and student hours' completion withautomatically generated calendars, student hours reports, facilitiesusage reports and other tracking and reporting functions. The system andmethod may be used to manage two or more “grade levels” of instructionwith two or more facilities or assets, including instructors and supportstaff, for which scheduling is required. The system and method can alsodistinguish among facilities, such as distinguishing between clinicalfacilities and simulation facilities, for record keeping purposes, usingthe present formulas and therefore without having to use advancedinformation technology such as pivot tables or other complicatedimplementations of data tracking.

An example (first embodiment) of the spreadsheet system and method ofscheduling, tracking and reporting usage of multiple nursing simulationlaboratories and generation of student hours' used reports is describedbelow and with reference to the accompanying Figures. For a college oruniversity level undergraduate/graduate school of nursing, thescheduling of simulation laboratories is not just a matter of allocatingcertain students and teachers to certain laboratories at certaintimes—the resource set up will also require coordination with the levelof the students who will use the simulation lab. In other words, asimulation laboratory will be prepared and configured differently for aclass of graduate school students than it will for incoming freshman orother lower level students who are on the lower end of the simulationlearning curve. Therefore, a tracking and reporting system must be ableto record and report the grade level of the students scheduled to usethe lab to make the scheduling function of the system easy to use, asthe labs are reconfigured throughout the day to meet the differing needsof the scheduled users. In the present invention, “grade level”designation is accomplished in part in a user-friendly way by using theFormat Painter function of the spreadsheet to code the grade levels incolor. Basic Instructions for color coding are outlined at the top ofthe spreadsheet for simplified visual identification (as shown in thecolor Figures, pale yellow—freshman; blue—sophomore; orange—junior;purple—senior; pink—second degree; grey—graduate level; ot—other, butchoice of actual colors is arbitrary and can be customized by any user.Particular formulas are used for data entry and implementation of thepresent system and method as described in detail below.

Referring now to FIG. 1, a screen shot of the “Summary” layout sheet,the “Summary” layout sheet is the primary data screen for data entry forthe first embodiment of the invention. By entering coded datarepresenting student level, simulation or non-simulation type, whetherentry represents typical student level experience, student cycling hours(hours for a student experience within the reserved lab hours), labhours and course title, the lab space/time is reserved by observing thefollowing data entry protocol: Positions 1, 2: HR to represent thatnumbers to follow are Room Reserved Hours; Positions 3, 4, 5: Hoursscheduled formatted #.# (number point number); Positions 6, 7, 8, 9:Dash (-) and Student level: -fr—freshman, -so—sophomore, -jr—junior,-sr—senior, -sd—second degree, -gr—graduate level, -ot—other, followedby Dash (-); Positions 10, 11, 12: Hours scheduled for individualstudent level experiences within Reserved Room formatted #.# (numberpoint number); Position 13: -(dash); Positions 14- . . . : CourseInformation including ‘SIM’ if simulation, null if not simulation,‘Stdnt’ if represents a typical student level experience, and anyadditional classifications determined by the user (may includeinstructor name, etc). As described above, basic instructions for colorcoding are outlined at the top of the spreadsheet for simplified visualidentification. In order to determine the total hours each room isscheduled, the following formula is used on this Summary layoutspreadsheet: =Tally!$Q178&″Hrs: ″&Tally!$X178 (formula copies the titleof data being summed and copies the summed hours, minimizing opportunityfor error). In order to determine total hours scheduled for a studentlevel (freshman (fr), sophomore (so) and so on), the following formulasare used:=SUM(Tally!J5:J175,Tally!X5:X175,Tally!AL5:AL175,Tally!AZ5:AZ175,Tally!BN5:BN175,Tally!CB5:CB175,TallyCP5:CP175,Tally!DD5:DD175,Tally!DR5:DR175), =SUM(‘Tally SIM’!J175+‘TallySIM’!X175+‘Tally SIM’!AL175+‘Tally SIM’!AZ175+‘Tally SIM’!BN175+‘TallySIM’!CB175+‘Tally SIM’!CP175+‘Tally SIM’!DD175+‘Tally SIM’!DR175),=SUM(‘Tally Stdnt’!J175+‘Tally Stdnt’!X175+‘Tally Stdnt’!AL175+‘TallyStdnt’!AZ175+‘Tally Stdnt’!BN175+‘Tally Stdnt’!CB175+‘TallyStdnt’!CP175+‘Tally Stdnt’!DD175+‘Tally Stdnt’!DR175), and =SUM(‘TallyStdnt SIM’!J175+‘Tally Stdnt SIM’!X175+‘Tally Stdnt SIM’!AL175+‘TallyStdnt SIM’!AZ175+‘Tally Stdnt SIM’!BN175+‘Tally Stdnt SIM’!CB175+‘TallyStdnt SIM’!CP175+‘Tally Stdnt SIM’!DD175+‘Tally Stdnt SIM’!DR175). Thetotal hours' completed per level, total simulation hours, total typicalstudent experience per level, and typical student simulation experienceper level is then available to any teacher responsible for classes atthat level, with manual adjustment thereafter for individual classmember absences (in other words, this system does not purport to trackindividual training time completion per individual student, but rathertracks and reports training time completion by student level and typicalhours for typical student experience (total and simulation) by studentlevel, from which individual training time completion can be easilycustomized by the teacher who takes attendance in class.) Time slotsthat are still available are represented by fields left white/uncolored,because the user manually colors each time slot at the time the room isscheduled to give a visual indication of level of simulation laboratoryuse for the scheduled period. The primary functions of this “Summary”sheet therefore are: a) when a single coded data entry is made withunrelated classifying text strings and locked in (by depressing theenter key or moving to another field), the hours are updated as coded(that is, total hours the room or lab is scheduled, total hours perstudent level, total hours for simulation per student level, total hoursfor typical student within student level, and total simulation hours fortypical student within student level are updated overall to reflectadditional hours as the corresponding entries are made); b) thecorresponding student level sheet (Freshman, Sophomore, Junior, etc.) isupdated by duplicating the single coded data entry field onto theappropriate student level sheet; and c) enables the user to query withmultiple criteria (unrelated text strings, with no known limit to thenumber of variables) to sum total hours and count occurrences of userdefined criteria, which can be redefined for additional queries.

Referring now to FIG. 2, FIG. 2 is a screen shot of the “Tally” screenof the present spreadsheet, used in the first embodiment of the presentsystem and method. The dates represented in Column A are copied fromSummary Sheet utilizing a formula corresponding to the Summary sheet,formula =(Summary!A10), so that when the Summary sheet is updated, theTally sheets are automatically updated. Column headings (Column C, 502Library-Formula, 502 Library-Tally, fr, so, jr, etc.) are identifiersfor ease of formula development and maintenance. Formulas to filter byroom and student level are represented in the pale yellow cells and arevariations of: a.=IF(ISNUMBER((FIND(“fr-”,Summary!$C158))),MID(Summary!$C158,3,3),0); i.ISNUMBER—defining data to be extracted as a number; ii.FIND(“fr-”,Summary!$C158—to look at Summary sheet, absolute column C,varying row 158 to determine if “fr-” is true; iii.MID(Summary!$C158,3,3),0)—extract from Summary sheet, absolute column C,varying row 158, beginning position 3, to include positions (3, 4, 5),if true, else return 0; b. =IF(CW5=FALSE,VALUE(0),VALUE(CW5))—becausethe data returned with the preceding formula was incalculable, thecolumn could not be summed, a supplemental formula to translate thenumeric value was necessary; i. (CW5=FALSE,VALUE(0)—if varying field CW5is false, return 0; ii. VALUE(CW5)—if the field is true, return thevalue of the field. The columns are summed for each level, formula=SUM(J5:J175). Sheets for Tally SIM, Tally Stdnt, Tally Stdnt SIM andTally Open Query utilize the same governing formula and do not appearherein because the Tally Sheet is representative of the “tally”functions.

Referring now to FIG. 3, which is the Freshman screen of the firstembodiment which is further typical of any student level of any systemwithin the concept of this invention, the purpose of this sheet is todisplay entries for the “Freshman” student level exclusively. This sheetstructure and function is repeated for any/all student levels for asmany tabs or screens as the spreadsheet program will accommodate.Additional criteria can be identified and summed. These entries are notcolor coded because all data is exclusive to the level. The structure ofthis worksheet (dates, headings, etc.) is copied using formula,=(Summary!A10), so that when the Summary sheet is updated all relatedsheets (Tally, Freshman, etc.) are updated. Total hours for each levelare displayed and there is likewise display of all rooms/labs scheduledfor the applicable student level. The Freshman level sheet is updated byduplicating the single coded data entry field using formula,=IF(ISNUMBER(FIND(“fr-”,Summary!$C11)),Summary!$C11,“ ”).

FIG. 4 is the “Sophomore” sheet layout and is similar to or the same asFIG. 3 except, for the first embodiment, the sheet shows a differentlevel of student assigned to the laboratories or other scheduledresources. The same formulas, =(Summary!A10) and=IF(ISNUMBER(FIND(“fr-”,Summary!$C11)),Summary!$C11,“ ”), govern thisand any other student-level specific sheet layout in the spreadsheet ofthe present system and method. The Figures for Junior and Seniortherefore do not appear herein because the Freshman and Sophomore sheetsare representative of any grade level sheet and one skilled in the artcan adapt the student grade levels to any student grade level systemthat the present invention is used to manage, from K-12 to graduate andpost-graduate or any student level scheme identifiable with successioncriteria. FIG. 5, showing the screen for “Second Degree” isrepresentative of a different or successive level of training, forexample, a candidate who has already finished undergraduate course workand is undertaking another (“second”) degree of study.

Referring now to FIG. 6 is the “Open Query” sheet layout and is similarto FIGS. 3-5 except that it represents the output from a user definedmultiple-criteria (unrelated text strings, with no known limit to thenumber of variables) query and sums total hours and counts occurrencesof user defined criteria. Again, a purpose of this sheet is to displayentries that satisfy the user defined criteria exclusively in printableformat.

Referring now to FIG. 7, which is the “Labs 550-551” screen, a tab inthe spreadsheet is used to represent exclusively lab/skill developmentand simulations as to facilities as scheduled. Although the sheet isentitled “Labs 550-551” for the purpose of the first embodiment, allphysical facilities scheduled by the present system and method may bedisplayed on this sheet regardless of the name of each facility. Forinstitutional management purposes, this screen becomes a tracking toolwith evidence to managers, and as necessary to the applicableinstitutional administration, of scheduling density which suggests thatadditional facilities should be planned and constructed.

The present system and method, described here in part as beingimplemented on an Excel or similar spreadsheet, can be implemented onvirtually any computer spreadsheet, including but not limited to opensource software such as the software known as Open Office at thiswriting.

The above first embodiment of the invention is very particular to anundergraduate/graduate nursing school at a University, providingfacilities tracking and student hours completion reporting as describedabove and shown in detail in FIGS. 1-7. However, the invention appliesto any educational or training setting in which two or more grade levelsof instruction, two or more classifications of training (simulation andnon-simulation), or typical student experience within grade level needto be distinguished throughout scheduling and tracking of two or moretraining facilities with constant updated reporting of student hours'completed per level and constantly updated scheduling information (withgrade designation per schedule entry) per facility. Generic formulas,then, generified to grade level “xl” as variably specified stillfiltering by grade level and room may be variations of the following: a.=IF(ISNUMBER(FIND(“xl-”,Summary!$J10))*(FIND(“SIM-”,Summary!$J10)),MID(Summary!$J10,3,3),0);i. ISNUMBER—defining data to be extracted as a number; ii.FIND(“fr-”,Summary!$J10—to look at Summary sheet, absolute column J,varying row 10 to determine if “fr-” is true; iii.FIND(“SIM-”,Summary!$J10—to look at Summary sheet, absolute column J,varying row 10 to determine if “SIM” is true; iv.MID(Summary!$J10,3,3),0)—extract from Summary sheet, absolute column J,varying row 10, beginning position 3, to include positions (3, 4, 5), iftrue, else return 0; b. =IF(CW5=FALSE,VALUE(0),VALUE(CW5))—because thedata returned with the preceding formula was incalculable, the columncould not be summed, a supplemental formula to translate the numericvalue was necessary; i. (CW5=FALSE,VALUE(0)—if varying field CW5 isfalse, return 0; ii. VALUE(CW5)—if the field is true, return the valueof the field. The columns are summed for each level, formula=SUM(J5:J175).

The system and method described herein satisfies the following needs: 1)Combined calendar (color coded by day of week) and room assignment andallotment of hours; 2) Novice-level, single-cell, multiple-criteria dataentry, color coding by student level (utilizing paint brush), withon-screen instructions such as (fr-4.0-N244 Lab SIM); 3) Single-cellstudent level classification, retrieval and totaling on Tally Sheet(simulation classification, infinite classification—64 nesting levels,8,000 characters) utilizing both a unique formula=IF(ISNUMBER(FIND(“fr-”,Summary!$J10))*(FIND(“SIM-”,Summary!$J10)),MID(Summary!$J10,3,3),0),and formula (CW5=FALSE,VALUE(0); 4) Automatically summed totals by room,student level, simulation classification, infinite classification, etc.on Summary Sheet utilizing formulas =Tally!$C178&″ Hrs: ″&Tally!$J178,and=SUM(Tally!K5:K175,Tally!Y5:Y175,Tally!AM5:AM175,Tally!BA5:BA175,Tally!BO5:BO175,Tally!CC5:CC175,Tally!CQ5:CQ175,Tally!DE5:DE175,Tally!DS5:DS175);5) Automatically summed totals by student level, simulationclassification, infinite classification, etc on individualized studentlevel sheets utilizing formula=SUM(Tally!K5:K175,Tally!Y5:Y175,Tally!AM5:AM175,Tally!BA5:BA175,Tally!BO5:BO175,Tally!CC5:CC175,Tally!CQ5:CQ175,Tally!DE5:DE175,Tally!DS5:DS175);6) the structure of the Summary Sheet is copied to the student levelsheets by formula, =(Summary!A10), so that when the Summary sheet isupdated all related sheets (Tally, Freshman, etc.) are updated; and 7)the Maintenance/customization for a new calendar period and additionalfiltering criteria is completed via a combination of find/replace andcomplex macro functions.

An innovative feature of the present invention is that a single cell,with multiple non-adjacent unrelated text strings, can be filtered andhave data extracted for reporting according to this specification.Because the system and method can track all desired differentials (suchas whether a training facility is “simulation” or “non-simulation”), itis now possible to have Grade Level A taught Course B by Instructor C ina simulation capacity and the method can filter for all these featureseither individually or grouped. The importance of this innovation isthat it is much simpler for the user to achieve tracking and reportingas just described rather than to have to use advanced features ofspreadsheet usage such as Pivot Table or Advanced Filtering, which areat this writing unfamiliar and inconvenient to many spreadsheet users,whereas single cell entry is easily learned and repeated. In otherwords, single cell filtering according to the present invention takes amyriad of information and makes it database friendly, which in turnmakes the present system and method very easy and effective to use.Notwithstanding the simplicity of the system, macros can be added asdesired, for example to customize and update individual system facets.The end user is prompted to supply customizing headers (room numbers,student levels) and additional filters for summing (Sim, non-Sim,Instructor, etc.). Nonetheless, the present system as described may beused successfully without any added macros or other features.

Indeed, the present single cell entry can be applied to track virtuallyany dynamic multi-criteria system. Because the broadest application ofthe present innovation is a multi-criteria filter row formula, such afilter row formula can be defined and modified by the user as preferredat any time (additional rows can be added for multi-criteriacomparisons), even using just the single cell data entry as describedelsewhere herein. Just as the user can query the spreadsheet as to howmany (sum) and how many occurrences of (count) there are for:[freshman],[lab], [course#], [SIM], [Instructor], [any variable] andetc., with no known limit to the number of variables, this approach maybe extrapolated to any other dynamic multi-criteria system's variables.For example, one could track instructor workload for several teachersover multiple classes in multiple subjects the same way, using multiplevariables and “sum” and “count” together to achieve a joint function(both sum and count) that spreadsheets heretofore have not been lookedto achieve. Typically, multi-criteria dynamic systems have heretoforebeen managed using a database instead of a spreadsheet, or at least, ifby spreadsheet, using the advanced spreadsheet features referred toearlier in this paragraph. By “multi-criteria” is meant at least twocriteria which require summing and at least two criteria which requirecounting.

In a second embodiment of the invention, a more elaborate array offormulas are populated into the spreadsheet to accomplish the samegeneral goal of data entry and automated computer processing offacilities scheduling information in a spreadsheet, in which thefacilities scheduling requires tracking of hours scheduled as well astracking and reporting of two or more user grade levels xl, at least oneuser experience xe, and at least one user experience subset xs, thelatter of which is usually but not necessarily a “SIM” experience, thatis, a simulation experience as a subset of total student experience. Thereason “student experience” is important is that when classes arescheduled into a facility and there are multiple students in a class,hands-on laboratory or simulation experience for that student may wellbe for a shorter time than the class is scheduled into the facility, butfor licensure or academic reasons it will be very important to track theindividual student experience (including simulation experience, which isusually a subset of laboratory or other experience overall) to reportindividual student achievements and training hours. When a class isscheduled to use a particularly laboratory or other facility, then,“student experience” or a typical subset “student simulation experience”can track usage for each individual student, as well as for the class asa whole. The overview of the second embodiment of the invention is toimplement entry and capture of all the quantitative scheduling data,together with optional and potentially unpredictable text strings thatmay accompany complex facilities' scheduling data entry. This datacapture means that hours scheduled, user grade levels, studentexperience, and student experience subset, etc., are tracked along withadditional optional data, by entering data in a single entry location,such that the data may be filtered, summed and counted and the entiredata event is summarized automatically in various single cells that areeasy for a user to consult, read and understand. In this way, by singledata entry of scheduling data, all output data is available incustomized cells as outputs to a user, as described herein, by operationof the formulas in the spreadsheet.

Although the second embodiment of the invention is conceptually similarto the first embodiment described above, it uses different formulas toachieve similar results in a similar way. The best way to articulate thesecond embodiment of the invention is to provide the following detailedexample, in association with FIGS. 8-17 herewith.

Example 1

Referring now to FIGS. 8-17, the Figures show a series of screen shotsrepresentative of the spreadsheet display of the second embodiment ofthe present invention.

Referring to FIG. 8, a display indicates the coding convention to beused, in the yellow section of the Summary Sheet at columns C-J, row 1.The instruction for the purpose of this example reads, “CODING: HoursRoom utilized (HR#.#); Dash (-); Level (fr, so, jr, sr, sd); Dash (-);Hours (#.#); Dash (-); If Simulation (SIM); If represents typicalstudent experience (Stdnt); Ex: HR3.0-sr-3.0-Course ABCD1234 SIM Stdnt.”In other words, this coding instruction provides the format for dataentry, on the Summary sheet, for any row (calendar date and time) orcolumn (facility), by hours followed by level (“xl”) followed by studentexperience specified as to SIM if applicable. On the Summary Sheet,also, multi-criteria filters may be added to the cells at C-J row 9 withthe convention of one text string per cell. One of the aspects of theinvention that makes the present spreadsheet so easy for the user isthat all actual data entry (that is, calendar entry, not customization)takes place on the Summary Sheet and is extremely intuitive—the userselects the column for the applicability facility to be scheduled, andthen choose the calendar date (divided by am or pm) by spreadsheet rowas shown in FIG. 8. As long as the data is entered according to theprovided Coding instructions, the rest of the spreadsheet and itsformulas function as follows, automatically, to provide an output to auser.

Referring now to FIG. 17, which represents the Customize sheet of thisexample, all cells accept customization entry, and by simple updatingcan copy/designate room description, level description and level codes,and first date of calendar. For example, CELL F14=DATE(E14,C14,D14)combines three cells to make 1 date cell to create a beginning date forthe calendar, which is then fed into the Summary Sheet. To set the“student level” classifications using the Customize sheet, use theformulas “CELL C3, CELL D3 freshman—fr-=Customize!C7&“-”&Customize!C8sophomore—so-=Customize!D7&“-”&Customize!D8 and etc.

Referring again to FIG. 8, Summary Sheet, the following formulas set thefirst date: for CELL C11 Sun, August 21=Customize!$F$14; for CELL C13Mon, August 22=SUM(Customize!$F$14+1) and thus by +1, +2, etc. set thebalance of the calendar.

Referring to all of FIGS. 8-17, various formulas are implemented asdescribed below.

The following formula takes totals from the Tally tab and CELL C4, CELLD4 Number representing # fr (freshman) level is =Tally!L739; Numberrepresenting # so (sophomore) level is =Tally!M739 etc.

The following formulas copy the room description and tag “Hrs:’ from theTally sheet (the room description originates from the Customize sheet)CELL C10 for 502 Library Hrs: # of hours allotted to room=Tally!C4&″Hrs: ″&Tally!C739 and CELL D10 for 502 Comp Lab Hrs: # ofhours allotted to room =Tally!D4&″ Hrs: ″&Tally!D739.

On the Freshman Sheet, FIG. 9, (and analogously on all other levels so,jr, sr, sd, gr, ot,) the following formulas copy level description andcode from the Summary sheet: CELL C4, CELL D4 forfreshman—fr-=(Summary!C3) and for sophomore—so-=(Summary!D3); as do CELLA11, CELL A13 for Sun, August 21=(Summary!A11), and for Mon, August22=(Summary!A13). The following formulas copy the totals by level, forSIM, for stdnt, and for stdnt/SIM: CELL C5, CELL C6, CELL D5; Freshmantotal for level #=(Summary!C4); Freshman SIM #=(Summary!C5); Sophomoretotal for level #=(Summary!D4). The following formulas copy the roomdescription from the Customize sheet: CELL C10, CELL D10 for 502 Library=Customize!C2; and for 502 Comp Lab =Customize!D2. The followingformulas copy the data entered on the Summary sheet if “xl-” is true; ifnot the formula adds a space: CELL C11, CELL C12, CELL D11. If cell C11(C12, D11, etc.) on Summary sheet contains “fr-” copies data entered incell C11 (C12, D11, etc), if not enters [space]. See also the followingformulas: =IF(ISNUMBER(FIND(“fr-”,Summary!C11)),Summary!C11,“ ”);=IF(ISNUMBER(FIND(“fr-”,Summary!C12)),Summary!C12,“ ”); and=IF(ISNUMBER(FIND(“fr-”,Summary!D11)),Summary!D11,“ ”).

Referring now to FIG. 11, the “Open Query” sheet, the following formulascopy data as described from Summary sheet, Customize sheet and TallySheet:

-   -   These formulas copy level description and code from Summary        sheet:    -   CELL C4, CELL D4    -   freshman—fr-=(Summary!C3)    -   sophomore—so-=(Summary!D3)    -   These formulas copy date from Summary sheet:    -   CELL A11, CELL A13    -   Sun, August 21=(Summary!A11)    -   Mon, August 22=(Summary!A13)    -   These formulas copy the totals by level, for SIM, for stdnt, for        stdnt/SIM:    -   CELL C4, CELL C5, CELL C6, CELL C7, CELL D4    -   Freshman total for level #=(Summary!C4)    -   Freshman SIM #=(Summary!C5)    -   Freshman stdnt #=(Summary!C6)    -   Freshman stdnt/SIM #=(Summary!C7)    -   Sophomore total for level #=(Summary!D4)    -   These formulas copy the room description from the Customize        sheet:    -   CELL C10, CELL D10    -   502 Library=Customize!C2    -   502 Comp Lab=Customize!D2    -   These formulas copy the data entered on Summary sheet if “xl-”        is true, if not puts in [space]:    -   CELL, C11, CELL C12, CELL D11    -   If cell C11 (C12, D11, etc.) on Summary sheet contains defined        filter data and copies data entered in cell C11 (C12, D11, etc)        if true, if not enters [space]    -   =IF(ISNUMBER((FIND(Summary!$C$9,Summary!    -   $C11))*(FIND(Summary!$D$9,Summary!    -   $C11))*(FIND(Summary!$E$9,Summary!    -   $C11))*(FIND(Summary!F$9,Summary!    -   $C11))*(FIND(Summary!$H$9,Summary!    -   $C11))*(FIND(Summary!$H$9,Summary!$C11))),(Summary!    -   $C11),“ ”)    -   =IF(ISNUMBER((FIND(Summary!$C$9,Summary!    -   $C12))*(FIND(Summary!$D$9,Summary!    -   $C12))*(FIND(Summary!$E$9,Summary!    -   $C12))*(FIND(Summary!$F$9,Summary!    -   $C12))*(FIND(Summary!$G$9,Summary!    -   $C12))*(FIND(Summary!$H$9,Summary!$C12))),(Summary!    -   $C12),“ ”)    -   =IF(ISNUMBER((FIND(Summary!$C$9,Summary!    -   $D11))*(FIND(Summary!$D$9,Summary!    -   $D11))*(FIND(Summary!$E$9,Summary!    -   $D11))*(FIND(Summary!$F$9,Summary!    -   $D11))*(FIND(Summary!$G$9,Summary!    -   $D11))*(FIND(Summary!$H$9,Summary!$D11))),(Summary!    -   $D11),“ ”)    -   These formulas copy the totals from the Tally sheet:    -   CELL I9, CELL J9    -   Total Hours for multi-criteria filter=SUM(Tally!    -   AN739:AV739)    -   Total count of occurrences for multi-criteria filler        -   =SUM(Tally!AN740:AV740)

Referring now to FIG. 16, the “Selected Period” sheet, the followingformulas copy data as described from the Summary sheet and Tally sheet.

-   -   These formulas copy the level description and code from the        Summary sheet as follows:    -   CELL C4, CELL D4    -   freshman—fr-=(Summary!C3)    -   sophomore—so-=(Summary!D3)    -   These formulas copy date from Summary sheet    -   CELL A11, CELL A13    -   Sun, August 21=(Summary!A11)    -   Mon, August 22=(Summary!A13)    -   These formulas copy the totals by level, for SIM, for stdnt, for        stdnt/SIM ONLY for selected dale period and defined criteria        from the Tally Sheet    -   CELL C5, CELL C6, CELL C7, CELL C8, CELL D5    -   Freshman total for level #=Tally!CS739    -   Freshman SIM #=Tally!DN739    -   Freshman stdnt #=Tally!E1739    -   Freshman stdnt/SIM #=Tally!FD739    -   Sophomore total for level #=Tally!CV739    -   These formulas copy the room description and totals ONLY for the        selected date period and defined criteria from the Tally sheet    -   CELL C10, CELL D10    -   502 Library=Tally!CH4&″ Hrs: ″&Tally!CH739    -   502 Comp Lab=Tally!CI4&″ Hrs: ″&Tally!CI739    -   These formulas copy the data entered on Summary sheet if “xl-”        is true, if not enters [space]    -   CELL C11, CELL C12, CELL D11    -   If cell C11 (C12, D11, etc.) on Summary sheet is on or within        selected date period and contains defined fitter data, then        copies data entered in cell C11 (C12, D11, etc) if true, if not        enters [space]    -   =IF(ISNUMBER((FIND(Summary!$C$9,Summary!    -   $C11))*(FIND(Summary!$D$9,Summary!    -   $C11))*(FIND(Summary!$E$9,Summary!    -   $C11))*(FIND(Summary!$F$9,Summary!    -   $C11))*(FIND(Summary!$G$9,Summary!    -   $C11))*(FIND(Summary!$H$9,Summary!$C11))),(Summary!    -   $C11),“ ”)    -   =IF(ISNUMBER((FIND(Summary!$C$9,Summary!    -   $C12))*(FIND(Summary!$D$9,Summary!    -   $C12))*(FIND*Summary!$E$9,Summary!    -   $C12))*(FIND(Summary!$F$9,Summary!    -   $C12))*(FIND(Summary!$G$9,Summary!    -   $C12))*(FIND(Summary!$H$9,Summary!$C12))),(Summary!    -   $C12),“ ”)    -   =IF(ISNUMBER((FIND(Summary!$C$9,Summary!    -   $D11))*(FIND(Summary!$D$9,Summary!    -   $D11))*(FIND(Summary!$E$9,Summary!    -   $D11))*(FIND(Summary!$F$9,Summary!    -   $D11))*(FIND(Summary!$G$9,Summary!    -   $D11))*(FIND(Summary!$H$9,Summary!$D11))),(Summary!    -   $D11),“ ”)    -   These formulas copy totals from the Tally sheet:    -   CELL I9 is total Hours for selected date period multi-criteria        filter        -   =SUM(Tally!CH739:CP739)    -   CELL J9 is total count of occurrences for selected date period        multi-criteria filter        -   =SUM(Tally!CH740:CP740)

Referring now to FIGS. 13, 14 and 15, which are three screen shotsdisplaying columns of the Tally Sheet, the Primary Headings are typed infor easy identification without formulas. The following formulas andconventions are used on the Tally Sheet:

-   -   These formulas set up headings and subheadings:    -   Room Hr Totals-Formula (both headings have same subheadings)    -   Multi-Criteria Filter        -   CELL C4-502 Library from Customize sheet        -   =Customize!$C$2        -   CELL D4-502 Comp Lab from Customize sheet        -   =Customize!$D$2    -   Level Totals (each heading has same subheadings)    -   Level SIM Totals    -   Level Totals Student    -   Level SIM Student Totals        -   CELL L4-Fr-from Customize sheet        -   =Customize!$C$8        -   CELL M4-So-from Customize sheet        -   =Customize!$D$8    -   SelectPeriod & Any/All Criteria Filter        -   CELL CH4-502 Library from Customize sheet        -   =Customize!$C$2        -   CELL CI4-502 Comp Lab from Customize sheet        -   =Customize!$D$2    -   SelectPeriod & Any/All Criteria-Level Totals for Columns    -   SelectPeriod & Any/All Criteria-Level SIM Totals for Columns    -   SelectPeriod & Any/All Criteria-Level Student for Columns    -   SelectPeriod & Any/All Criteria-Level SIM & Student Totals        -   CELL CQ4-fr-C-G from Customize sheet        -   =Customize!$C$8&“C-G”        -   CELL CR4-fr-H-K from Customize sheet        -   =Customize!$C$8&“H-K”        -   CELL CS4-Total from Customize sheet        -   =Customize!$C$8&“Total”        -   CELL CT4-so-C-G from Customize sheet        -   =Customize!$D$8&“C-G”        -   CELL CU4-so-H-K from Customize sheet        -   =Customize!$D$8&“H-K”        -   CELL CV-Total from Customize sheet        -   =Customize!$D$8&“Total”    -   These formulas copy date from Summary sheet:    -   CELL A5 Sun, August 21=(Summary!A11)    -   CELL A13 Mon, August 22=(Summary!A13) etc.    -   These calculating formulas from the Tally sheet show 3 examples        of each to establish a pattern and demonstrate continuity.    -   Room Hr Totals-Formula—the column sums from these are “copied”        to Summary sheet row 10, columns C-K:    -   CELL C5 for 502 Library represents number of hours room is        scheduled for use in cell C11; if “HR” is found in C11 then        returns 3 numbers from third position, else 0    -   =IF(ISNUMBER(FIND(“HR”,Summary!$C11)),MID(Summary!    -   $C11,3,3)*1,0)    -   CELL C739 for 502 Library represents number of hours for year        scheduled for specified room    -   =SUM(C5:C738)    -   CELL C6 for 502 Library represents number of hours room is        scheduled for use in cell C12; if “HR” is found in C12 then        returns 3 numbers from third position, else 0    -   =IF(ISNUMBER(FIND(“HR”,Summary!$C12)),MID(Summary!    -   $C12,3,3)*1,0)    -   CELL C739 for 502 Library represents number of hours for year        scheduled for specified room    -   =SUM(C5:C738)    -   CELL D5 for 502 Comp Lab represents number of hours room is        scheduled for use in cell D11; if “HR” is found in D11 then        returns 3 numbers from third position, else 0    -   =IF(ISNUMBER(FIND(“HR”,Summary!$D11)),MID(Summary!    -   $D11,3,3)*1,0)    -   CELL D739 for 502 Comp Lab represents number of hours for year        scheduled for specified room    -   =SUM(D5:D738)    -   Level Totals—the column sums from these are “copied” to Summary        sheet row 4, columns C-K:    -   CELL L5 for fr-represents number of hours for all rooms        scheduled for freshman; if “fr-” is found in        Summary!C11,D11,E11,F11,G11,H11,I11,J11 and/or K11 returns sum        of 3 numbers from each true cell third position, else 0    -   =SUM(IF(ISNUMBER(FIND(“fr-”,Summary!$C11)),MID(Summary!    -   $C11,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $D11)),MID(Summary!    -   $D11,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $E11),MID(Summary!    -   $E11,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $F11)),MID(Summary!    -   $F11,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $G11)),MID(Summary!    -   $G11,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $H11)),MID(Summary!    -   $H11,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $I11)),MID(Summary!    -   $I11,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $J11)),MID(Summary!    -   $J11,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $K11)),MID(Summary!$K11,3,3)*1,0))    -   CELL L6 for fr-represents number of hours for all rooms        scheduled for freshman; if “fr-” is found in Summary!        C12,D12,E12,F12,G12,H12,I12,J12 and/or K12 returns sum of 3        numbers from each true cell third position, else 0    -   =SUM(IF(ISNUMBER(FIND(“fr-”,Summary!$C12)),MID(Summary!    -   $C12,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $D12)),MID(Summary!    -   $D12,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $E12)),MID(Summary!    -   $E12,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $F12)),MID(Summary!    -   $F12,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $G12)),MID(Summary!    -   $G12,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $H12)),MID(Summary!    -   $H12,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $I12)),MID(Summary!    -   I12,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $J12)),MID(Summary!    -   $J12,3,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!    -   $K12)),MID(Summary!$K12,3,3)*1,0))    -   CELL L739 (for both CELLS L5 and L6) for fr—represents number of        hours for year for all rooms scheduled for freshman    -   =SUM(L5:L738)    -   CELL M5 for so-represents number of hours for all rooms        scheduled for sophomore; if “so-” is found in Summary!        C11,D11,E11,F11,G11,H11,I11,J11 and/or K11 returns sum of 3        numbers from each true cell third position, else 0    -   =SUM(IF(ISNUMBER(FIND(“so-”,Summary!$C11)),MID(Summary!    -   $C11,3,3)*1,0)+IF(ISNUMBER(FIND(“so-”,Summary!    -   $D11)),MID(Summary!    -   $D11,3,3)*1,0)+IF(ISNUMBER(FIND(“so-”,Summary!    -   $E11)),MID(Summary!    -   $E11,3,3)*1,0)+IF(ISNUMBER(FIND(“so-”,Summary!    -   $F11,3,3)),MID(Summary!    -   $F11,3,3)*1,0)+IF(ISNUMBER(FIND(“so-”,Summary!    -   $G11)),MID(Summary!    -   $G11,3,3)*1,0)+IF(ISNUMBER(FIND(“so-”,Summary!    -   $H11)),MID(Summary!    -   $H11,3,3)*1,0)+IF(ISNUMBER(FIND(“so-”,Summary!    -   $I11)),MID(Summary!    -   $I11,3,3)*1,0)+IF(ISNUMBER(FIND(“so-”,Summary!    -   $J11)),MID(Summary!    -   $J11,3,3)*1,0)+IF(ISNUMBER(FIND(“so-”,Summary!    -   $K11)),MID(Summary!$K11,3,3)*1,0))    -   CELL M739 for fr-represents number of hours for year for all        rooms scheduled for sophomore    -   =SUM(M5:M738)    -   Level SIM Totals—the column sums from these are “copied” to        Summary sheet row 5, columns C-K:    -   CELL S5 for fr-represents number of hours for all rooms        scheduled for freshman in SIM; if “fr-” and “SIM” are found in        Summary! C11,D11,E11,F11,G11,H11,I11,J11 and/or K11 returns sum        of 3 numbers from each true cell third position, else 0    -   =(SUM(IF(ISNUMBER((FIND(“fr-”,Summary!    -   $C11))*(FIND(“SIM”,Summary!$C11))),MID(Summary!    -   $C11,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $D11))*(FIND(“SIM”,Summary!$D11))),MID(Summary!    -   $D11,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $E11))*(FIND(“SIM”,Summary!$E11))),MID(Summary!    -   $E11,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $F11))*(FIND(“SIM”,Summary!$F11))),MID(Summary!    -   $F11,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $G11))*(FIND(“SIM”,Summary!$G11))),MID(Summary!    -   $G11,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $H11))*(FIND(“SIM”,Summary!$H11))),MID(Summary!    -   $H11,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $I11))*(FIND(“SIM”,Summary!$I11))),MID(Summary!    -   $I11,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $J11))*(FIND(“SIM”,Summary!$J11))),MID(Summary!    -   $J11,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $K11))*(FIND(“SIM”,Summary!$K11))),MID(Summary!    -   $K11,3,3),0)))    -   CELL S6 for fr-represents number of hours for all rooms        scheduled for freshman in SIM; if “fr-” and “SIM” are found in        Summary! C12,D12,E12,F12,G12,H12,I12,J12 and/or K12 returns sum        of 3 numbers from each true cell third position, else 0    -   =(SUM(IF(ISNUMBER((FIND(“fr-”,Summary!    -   $C12))*(FIND(“SIM”,Summary!$C12))),MID(Summary!    -   $C12,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $D12))*(FIND(“SIM”,Summary!$D12))),MID(Summary!    -   $D12,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $E12))*(FIND(“SIM”,Summary!$E12))),MID(Summary!    -   $E12,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $F12))*(FIND(“SIM”,Summary!$F12))),MID(Summary!    -   $F12,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $G12))*(FIND(“SIM”,Summary!$G12))),MID(Summary!    -   $G12,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $H12))*(FIND(“SIM”,Summary!$H12))),MID(Summary!    -   $H12,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $I12))*(FIND(“SIM”,Summary!$I12))),MID(Summary!    -   $I12,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $J12))*(FIND(“SIM”,Summary!$J12))),MID(Summary!    -   $J12,3,3),0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $K12))*(FIND(“SIM”,Summary!$K12))),MID(Summary!    -   $K12,3,3),0)))    -   CELL S739 (for both CELLS S5 and S6) for fr—represents number of        hours for year for all rooms scheduled for freshman in SIM    -   =SUM(S5:S738)    -   CELL T5 for so-represents number of hours for all rooms        scheduled for sophomore in SIM; if “so-” and “SIM” are found in        Summary! C11,D11,E11,F11,G11H11,I11,J11 and/or K11 returns sum        of 3 numbers from each true cell third position, else 0    -   =(SUM(IF(ISNUMBER((FIND(“so-”,Summary!    -   $C11))*(FIND(“SIM”,Summary!$C11))),MID(Summary!    -   $C11,3,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $D11)*(FIND(“SIM”,Summary!$D11))),MID(Summary!    -   $D11,3,3),0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $E11))*(FIND(“SIM”,Summary!$E11)),MID(Summary!    -   $E11,3,3),0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $F11))*(FIND(“SIM”,Summary!$F11))),MID(Summary!    -   $F11,3,3),0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $G11))*(FIND(“SIM”,Summary!$G11))),MID(Summary!    -   $G11,3,3),0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $H11))*(FIND(“SIM”,Summary!$H11))),MID(Summary!    -   $H11,3,3),0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $I11))*(FIND(“SIM”,Summary!$I11))),MID(Summary!    -   $I11,3,3),0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $J11))*(FIND(“SIM”,Summary!$J11))),MID(Summary!    -   $J11,3,3),0)+IF(ISNUMBER(FIND(“so-”,Summary!    -   $K11))*(FIND(“SIM”,Summary!$K11))),MID(Summary!    -   $K11,3,3),0)))    -   CELL T39 for fr-represents number of hours for year for all        rooms scheduled for sophomore in SIM    -   =SUM(T5:T738)    -   Level Totals Student (a typical Stdnt experience)—the column        sums from these are “copied” to Summary sheet row 6, columns        C-K:    -   CELL Z5 for fr—represents number of hours for all rooms        scheduled for freshman for Stdnt; if “fr-” and “Stdnt” are found        in Summary! C11,D11,E11,F11,G11,H11,I11,J11 and/or K11 returns        sum of 3 numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER((FIND(“fr-”,Summary!$C11))*    -   (FIND(“Stdnt”,Summary!$C11))),MID(Summary!    -   $C11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$D11))*    -   (FIND(“Stdnt”,Summary!$D11))),MID(Summary!    -   $D11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$E11))*    -   (FIND(“Stdnt”,Summary!$E11))),MID(Summary!    -   $E11,10,3)*0,1)+IF(ISNUMBER((FIND(“fr-”,Summary!$F11))*    -   (FIND(“Stdnt”,Summary!$F11))),MID(Summary!    -   $F11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$G11))*    -   (FIND(“Stdnt”,Summary!$G11))),MID(Summary!    -   $G11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$H11))*    -   (FIND(“Stdnt”,Summary!$H11))),MID(Summary!    -   $H11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$I11))*    -   (FIND(“Stdnt”,Summary!$I11))),MID(Summary!    -   $I11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$J11))*    -   (FIND(“Stdnt”,Summary!$J11))),MID(Summary!    -   $J11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$K11))*    -   (FIND(“Stdnt”,Summary!$K11))),MID(Summary!$K11,10,3)*1,0))    -   CELL Z6 for fr-represents number of hours for all rooms        scheduled for freshman for Stdnt; if “fr-” and “Stdnt” are found        in Summary! C12,D12,E12,F12,G12,H12,I12,J12 and/or K12 returns        sum of 3 numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER((FIND(“fr-”,Summary!$C12))*    -   (FIND(“Stdnt”,Summary!$C12))),MID(Summary!    -   $C12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$D12))*    -   (FIND(“Stdnt”,Summary!$D12))),MID(Summary!    -   $D12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$E12))*    -   (FIND(“Stdnt”,Summary!$E12))),MID(Summary!    -   $E12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$F12))*    -   (FIND(“Stdnt”,Summary!$F12))),MID(Summary!    -   $F12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$G12))*    -   (FIND(“Stdnt”,Summary!$G12))),MID(Summary!    -   $G12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$H12))*    -   (FIND(“Stdnt”,Summary!$H12))),MID(Summary!    -   $H12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$I12))*    -   (FIND(“Stdnt”,Summary!$I12))),MID(Summary!    -   $I12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$J12))*    -   (FIND(“Stdnt”,Summary!$J12))),MID(Summary!    -   $J12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$K12))*    -   (FIND(“Stdnt”,Summary!$K12))),MID(Summary!$K12,10,3)*1.0))    -   CELL Z739 (for both CELLS Z5 and Z6) for fr-represents number of        hours for year for all rooms scheduled for freshman for Stdnt    -   =SUM(Z5:Z738)    -   CELL AA5 for so-represents number of hours for all rooms        scheduled for sophomore for Stdnt; if “so-” and “Stdnt” are        found in Summary!    -   C11,D11,E11,F11,G11,H11,I11,J11 and/or K11 returns sum of 3        numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER((FIND(“so-”,Summary!$C11))*    -   (FIND(“Stdnt”,Summary!$C11))),MID(Summary!    -   $C11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$D11))*    -   (FIND(“Stdnt”,Summary!$D11))),MID(Summary!    -   $D11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$E11))*    -   (FIND(“Stdnt”,Summary!$E11))),MID(Summary!    -   $E11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$F11))*    -   (FIND(“Stdnt”,Summary!$F11))),MID(Summary!    -   $F11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$G11))*    -   (FIND(“Stdnt”,Summary!$G11))),MID(Summary!    -   $G11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$H11))*    -   (FIND(“Stdnt”,Summary!$H11))),MID(Summary!    -   $H11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$I11))*    -   (FIND(“Stdnt”,Summary!$I11))),MID(Summary!    -   $I11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$J11))*    -   (FIND(“Stdnt”,Summary!$J11))),MID(Summary!    -   $J11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$K11))*    -   (FIND(“Stdnt”,Summary!$K11))),MID(Summary!$K11,10,3)*1,0))    -   CELL AA39 for so-represents number of hours for year for all        rooms scheduled for sophomore for Stdnt    -   =SUM(AA5:A738)    -   Level SIM Student Totals—the column sums from these are “copied”        to Summary sheet row 7, columns C-K:    -   CELL AN5 for fr-represents number of hours for all rooms        scheduled for freshman for Stdnt in SIM; if “fr-” and “SIM” and        “Stdnt” are found in Summary!C11,D11,E11,F11,G11,H11,I11,J11        and/or K11 returns sum of 3 numbers from each true cell tenth        position, else 0    -   =SUM(IF(ISNUMBER((FIND(“fr-”,Summary!    -   $C11))*(FIND(“SIM”,Summary!$C11))*(FIND(“Stdnt”,Summary!    -   $C11))),MID(Summary!    -   $C11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$D11))*    -   (FIND(“SIM”,Summary!$D11))*(FIND(“Stdnt”,Summary!    -   $D11))),MID(Summary!    -   $D11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$E11))*    -   (FIND(“SIM”,Summary!$E11))*(FIND(“Stdnt”,Summary!    -   $E11))),MID(Summary!    -   $E11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$F11))*    -   (FIND(“SIM”,Summary!$F11))*(FIND(“Stdnt”,Summary!    -   $F11))),MID(Summary!    -   $F11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$G11))*    -   (FIND(“SIM”,Summary!$G11))*(FIND(“Stdnt”,Summary!    -   $G11))),MID(Summary!    -   G11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$H11))*    -   (FIND(“SIM”,Summary!$H11))*(FIND(“Stdnt”,Summary!    -   $H11))),MID(Summary!    -   $H11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$I11))*    -   (FIND(“SIM”,Summary!$I11))*(FIND(“Stdnt”,Summary!    -   $I11))),MID(Summary!    -   $I11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$J11))*    -   (FIND(“SIM”,Summary!$J11))*(FIND(“Stdnt”,Summary!    -   $J11))),MID(Summary!    -   $J11,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$K11))*    -   (FIND(“SIM”,Summary!$K11))*(FIND(“Stdnt”,Summary!    -   $K11))),MID(Summary!$K11,10,3)*1,0))    -   CELL AN6 for fr-represents number of hours for all rooms        scheduled for freshman for Stdnt in SIM; if “fr-” and “SIM” and        “Stdnt” are found in Summary!C12,D12,E12,F12,G12,H12,I12,J12        and/or K12 returns sum of 3 numbers from each true cell tenth        position, else 0    -   =SUM(IF(ISNUMBER((FIND(“fr-”,Summary!    -   $C12))*(FIND(“SIM”,Summary!$C12))*(FIND(“Stdnt”,Summary!    -   $C12))),MID(Summary!    -   $C12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$D12))*    -   (FIND(“SIM”,Summary!$D12))*(FIND(“Stdnt”,Summary!    -   $D12))),MID(Summary!    -   $D12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$E12))*    -   (FIND(“SIM”,Summary!$E12))*(FIND(“Stdnt”,Summary!    -   $E12))),MID(Summary!    -   $E12,10,3)*1,0)+IF(ISNUMBER(FIND(“fr-”,Summary!$F12))*    -   (FIND(“SIM”,Summary!$F12))*(FIND(“Stdnt”,Summary!    -   $F12))),MID(Summary!    -   $F12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$G12))*    -   (FIND(“SIM”,Summary!$G12))*(FIND(“Stdnt”,Summary!    -   $G12))),MID(Summary!    -   G12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$H12))*    -   (FIND(“SIM”,Summary!$H12))*(FIND(“Stdnt”,Summary!    -   $H12))),MID(Summary!    -   $H12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$I12))*    -   (FIND(“SIM”,Summary!$I12))*(FIND(“Stdnt”,Summary!    -   $I12))),MID(Summary!    -   $I12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$J12))*    -   (FIND(“SIM”,Summary!$J12))*(FIND(“Stdnt”,Summary!    -   $J12))),MID(Summary!    -   $J12,10,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!$K12))*    -   (FIND(“SIM”,Summary!$K12))*(FIND(“Stdnt”,Summary!    -   $K12))),MID(Summary!$K12,10,3)*1,0))    -   CELL AG739 (for both CELLS AG5 and AG6) for fr-represents number        of hours for year for all rooms scheduled for freshman for Stdnt        in SIM    -   =SUM(AG5:AG738)    -   CELL AO5 for so-represents number of hours for all rooms        scheduled for sophomore for Stdnt in SIM; if “so-” and “SIM” and        “Stdnt” are found in Summary!C11,D11,E11,F11,G11,H11,I11,J11        and/or K11 returns sum of 3 numbers from each true cell tenth        position, else 0    -   =SUM(IF(ISNUMBER((FIND(“so-”,Summary!    -   $C11))*(FIND(“SIM”,Summary!$C11))*(FIND(“Stdnt”,Summary!    -   $C11))),MID(Summary!    -   $C11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$D11))*    -   (FIND(“SIM”,Summary!$D11))*(FIND(“Stdnt”,Summary!    -   $D11))),MID(Summary!    -   $D11,10,3)*1.0)+IF(ISNUMBER(FIND(“so-”,Summary!$E11))*    -   (FIND(“SIM”,Summary!$E11))*(FIND(“Stdnt”,Summary!    -   $E11))),MID(Summary!    -   $E11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$F11))*    -   (FIND(“SIM”,Summary!$F11))*(FIND(“Stdnt”,Summary!    -   $F11))),MID(Summary!    -   $F11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$G11))*    -   (FIND(“SIM”,Summary!$G11))*(FIND(“Stdnt”,Summary!    -   $G11))),MID(Summary!    -   G11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$H11))*    -   (FIND(“SIM”,Summary!$H11))*(FIND(“Stdnt”,Summary!    -   $H11))),MID(Summary!    -   $H11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$I11))*    -   (FIND(“SIM”,Summary!$I11))*(FIND(“Stdnt”,Summary!    -   $I11))),MID(Summary!    -   $I11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$J11))*    -   (FIND(“SIM”,Summary!$J11))*(FIND(“Stdnt”,Summary!    -   $J11))),MID(Summary!    -   $J11,10,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!$K11))*    -   (FIND(“SIM”,Summary!$K11))*(FIND(“Stdnt”,Summary!    -   $K11))),MID(Summary!$K11,10,3)*1,0))    -   CELL AH739 for so-represents number of hours for year for all        rooms scheduled for sophomore for Stdnt in SIM    -   =SUM(AH5:AH38)    -   Multi-Criteria Filter—The column sum and count from these are        “copied” to both Summary sheet and Query sheet row 9, columns I        and J:    -   CELL AN5 for multiple-criteria represents number of hours for        room scheduled (502 Library) for defined filter; if criteria        defined on OpenQuery sheet in cells absolute cells        C9,D9,E9,F9,G9,H9 are found in cell Summary!C11 returns 3        numbers from cell if true third position, else 0    -   =SUM(IF(ISNUMBER((FIND(Summary!$C$9,Summary!$C11))*    -   (FIND(Summary!$D$9,Summary!$C11))*(FIND(Summary!    -   $E$9,Summary!$C11))*(FIND(Summary!$F$9,Summary!$C11))*    -   (FIND(Summary!$G$9,Summary!$C11))*(FIND(Summary!    -   $H$9,Summary!$C11))),MID(Summary!$C11,3,3)*1.0))    -   CELL AN6 for multiple-criteria represents number of hours for        room scheduled (502 Library) for defined filter; if criteria        defined on OpenQuery sheet in cells absolute cells        C9,D9,E9,F9,G9,H9 are found in cell Summary!C12 returns 3        numbers from cell if true third position, else 0    -   =SUM(IF(ISNUMBER((FIND(Summary!$C$9,Summary!$C12))*    -   (FIND(Summary!$D$9,Summary!$C12))*(FIND(Summary!    -   $E$9,Summary!$C12))*(FIND(Summary!$F$9,Summary!$C12))*    -   (FIND(Summary!$G$9,Summary!$C12))*(FIND(Summary!    -   $H$9,Summary!$C12))),MID(Summary!$C12,3,3)*1,0))    -   CELL AN739 (for both CELLS AN5 and AN6) represents number of        hours for column for room scheduled for defined filter    -   =SUM(AN5:AN738)    -   CELL AN740 (for both CELLS AN5 and AN6) represents count of        hours for column for room scheduled for defined filter if #        greater than 0    -   =COUNTIF(AN5:AN738,“>0”)    -   CELL AO5 for multiple-criteria represents number of hours for        room scheduled (502 Camp Lab) for defined filter; if criteria        defined on OpenQuery sheet in cells absolute cells        C9,D9,E9,F9,G9,H9 are found in cell Summary!D11 returns 3        numbers from cell if true third position, else 0    -   =SUM(IF(ISNUMBER((FIND(Summary!$C$9,Summary!$D11))*    -   (FIND(Summary!$D$9,Summary!$D11))*(FIND(Summary!    -   $E$9,Summary!$D11))*(FIND(Summary!$F$9,Summary!$D11))*    -   (FIND(Summary!$G$9,Summary!$D11))*(FIND(Summary!    -   $H$9,Summary!$D11))),MID(Summary!$D11,3,3)*1.0))    -   CELL AO739 represents number of hours for column for room        scheduled for defined filter    -   =SUM(AO5:AO738)    -   CELL AO740 represents count of hours for column for room        scheduled for defined filter if # greater than 0    -   =COUNTIF(AO5:AO738,“>0”)    -   SelectPeriod & Any/All Criteria Filter—the column sum and count        from these are “copied” to Selected Period sheet row 9, columns        I and J    -   CELL CH5 for multiple-criteria for select period represents        number of hours for room scheduled (502 Library) on or within        selected date period and defined filter; if criteria defined on        SelectPeriod sheet in cells absolute cells C9,D9,E9,F9,G9,H9 and        on or between dates specified on SelectPeriod sheet absolute        cells F1 and G1 are found in cell Summary!C11 returns 3 numbers        from cell if true third position, else 0    -   =SUM(IF(ISNUMBER((FIND(SelectedPeriod!$C$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$H$9,Summary!$C11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=Selected Period!    -   $H$1),MID(Summary!$C11,3,3)*1.0))    -   CELL CH6 for multiple-criteria for select period represents        number of hours for room scheduled (502 Library) on or within        selected date period and defined filter; if criteria defined on        SelectPeriod sheet in cells absolute cells C9,D9,E9,F9,G9,H9 and        on or between dates specified on SelectPeriod sheet absolute        cells F1 and G1 are found in cell Summary!C12 returns 3 numbers        from cell if true third position, else 0    -   =SUM(IF(ISNUMBER((FIND(SelectedPeriod!$C$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$H$9,Summary!$C12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!$C12,3,3)*1,0))    -   CELL CH739 (for both CELLS CH5 and CH6) represents number of        hours for column for room scheduled for defined filter and        selected period    -   =SUM(CH5:CH738)    -   CELL CH740 (for both CELLS CH5 and CH6) represents count of        hours for column for room scheduled for defined filter and        selected period if # greater than 0    -   =COUNTIF(CH5:CP738,“>0”)    -   CELL CI5 for multiple-criteria for select period represents        number of hours for room scheduled (502 Comp Lab) on or within        selected date period and defined filter; if criteria defined on        SelectPeriod sheet in cells absolute cells C9,D9,E9,F9,G9,H9 and        on or between dates specified on SelectPeriod sheet absolute        cells F1 and G1 are found in cell Summary!D11 returns 3 numbers        from cell if true third position, else 0    -   =SUM(IF(ISNUMBER((FIND(SelectedPeriod!$C$9,Summary!    -   $D11)*(FIND(SelectedPeriod!$D$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$H$9,Summary!$D11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary)!$D11,3,3)*1,0))    -   CELL CI739 represents number of hours for column for room        scheduled for defined filter and selected period    -   =SUM(CI5:CI738)    -   CELL CI740-columns CH thru CP for total count on Selected Period        sheet represents count of hours for column for room scheduled        for defined filter and selected period if # greater than 0    -   =COUNTIF(CI5:CI738,“>0”)    -   SelectPeriod & Any/All Criteria-Level Totals for Columns—Note:        due to size of formulas “C-G”+“H-K” to sum for each level—the        column sum and count from the summed are “copied” to Selected        Period sheet row 4, columns C through J    -   CELL CQ 5 for fr-C-G represents number of hours for all rooms in        columns C-G scheduled for freshman for any/all criteria        scheduled on or within selected date period; if “fr-” and        criteria defined on SelectPeriod sheet in cells absolute cells        C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary!C11,D11,E11,F11 and/or G11 returns sum of 3 numbers from        each true cell third position, else 0    -   =SUM(IF(ISNUMBER((FIND(“fr-”,Summary!    -   $C11))*(FIND(SelectedPcriod!$C$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$H$9,Summary!$C11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $C11,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $D11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$H$9,Summary!$D11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $D11,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $E11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$H$9,Summary!$E11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $E11,3,3)*1,0))+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $F11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$H$9,Summary!$F11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $F11,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $G11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$H$9,Summary!$G11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!$G11,3,3)*1,0))    -   CELL CR5 for fr-H-K represents number of hours for all rooms in        columns H-K scheduled for freshman for any/all criteria        scheduled on or within selected date period; if “fr-” and        criteria defined on SelectPeriod sheet in cells absolute cells        C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary!H11,I11,J11 and/or K11 returns sum of 3 numbers from        each true cell third position, else 0    -   =SUM(IF(ISNUMBER((FIND(“fr-”,Summary!    -   $H11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$H$9,Summary!$H11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $H11,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $I11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$H$9,Summary!$I11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I11,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $J11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$H$9,Summary!$J11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J11,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $K11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$H$9,Summary!$K11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11>=SelectedPeriod!    -   $H$1), MID(Summary!$K11,3,3)*1,0))    -   CELL CS5 for fr-Total represents number of hours for all rooms        C-G+H-K scheduled for freshman for any/all criteria scheduled on        or within selected date period; sum cells CQ & CR    -   =SUM(CQ5:CR5)    -   CELL CQ6 for fr-C-G represents number of hours for all rooms in        columns C-G scheduled for freshman for any/all criteria        scheduled on or within selected date period; if “fr-” and        criteria defined on SelectPeriod sheet in cells absolute cells        C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary!C12,D12,E12,F12 and/or G12 returns sum of 3 numbers from        each true cell third position, else 0    -   =SUM(IF(ISNUMBER((FIND(“fr-”,Summary!    -   $C12))*(FIND(SelectedPeriod!$C$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$H$9,Summary!$C12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $C12,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $D12))*(FIND(SelectedPeriod!$C$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$H$9,Summary!$D12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=Selected Period!    -   $H$1), MID(Summary!    -   $D12,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $E12))*(FIND(SelectedPeriod!$C$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$H$9,Summary!$E12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=Selected Period!    -   $H$1), MID(Summary!    -   $E12,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $F12))*(FIND(SelectedPeriod!$C$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$H$9,Summary!$F12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $F12,3,3)*1.0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $G12))*(FIND(SelectedPeriod!$C$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$H$9,Summary!$G12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!$G12,3,3)*1,0))    -   CELL CR6 for fr-H-K represents number of hours for all rooms in        columns H-K scheduled for freshman for any/all criteria        scheduled on or within selected date period; if “fr-” and        criteria defined on SelectPeriod sheet in cells absolute cells        C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary!H12,I12,J12 and/or K12 returns sum of 3 numbers from        each true cell third position, else 0    -   =SUM(IF(ISNUMBER((FIND(“fr-”,Summary!    -   $H12))*(FIND(SelectedPeriod!$C$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$H$9,Summary!$H12)))*Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12>=SelectedPeriod!    -   $H$1), MID(Summary!    -   $H12,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $I12))*(FIND(SelectedPeriod!$C$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$H$9,Summary!$I12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I12,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $J12))*(FIND(SelectedPeriod!$C$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$H$9,Summary!$J12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J12,3,3)*1,0)+IF(ISNUMBER((FIND(“fr-”,Summary!    -   $K12))*(FIND(SelectedPeriod!$C$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$H$9,Summary!$K12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!$K12,3,3)*1,0))    -   CELL CS6 for fr-Total represents number of hours for all rooms        C-G+H-K scheduled for freshman for any/all criteria scheduled on        or within selected date period; sum cells CQ & CR    -   =SUM(CQ5:CR5)    -   CELL CS739 for Totals for CELLS CQ & CR; sum column CS for total        hours for all rooms scheduled for freshman for any/all criteria        scheduled on or within selected date period    -   =SUM(CS5:CS738)    -   CELL CT5 for so-C-G represents number of hours for all rooms in        columns C-G scheduled for sophomore for any/all criteria        scheduled on or within selected date period; if “so-” and        criteria defined on SelectPeriod sheet in cells absolute cells        C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary!C11,D11,E11,F11 and/or G11 returns sum of 3 numbers from        each true cell third position, else 0    -   =SUM(IF(ISNUMBER((FIND(“so-”,Summary!    -   $C11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$H$9,Summary!$C11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $C11,3,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $D11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$H$9,Summary!$D11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $D11,3,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $E11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$H$9,Summary!$E11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $E11,3,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $F11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$H$9,Summary!$F11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $F11,3,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $G11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G11))*FIND(SelectedPeriod!$H$9,Summary!$G11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!$G11,3,3)*1.0))    -   CELL CU5 for so-H-K represents number of hours for all rooms in        columns H-K scheduled for sophomore for any/all criteria        scheduled on or within selected date period; if “so-” and        criteria defined on SelectPeriod sheet in cells absolute cells        C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary!H11,I11,J11 and/or K 11 returns sum of 3 numbers from        each true cell third position, else 0    -   =SUM(IF(ISNUMBER((FIND(“so-”,Summary!    -   $H11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$H$9,Summary!$H11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $H11,3,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $I11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$H$9,Summary!$I11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I11,3,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $J11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$H$9,Summary!$J11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J11,3,3)*1,0)+IF(ISNUMBER((FIND(“so-”,Summary!    -   $K11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$H$9,Summary!$K11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=Selected Period!    -   $H$1), MID(Summary!$K11,3,3)*1,0))    -   CELL CV5 for so-Total represents number of hours for all rooms        C-G+H-K scheduled for sophomore for any/all criteria scheduled        on or within selected date period; sum cells CT & CU    -   =SUM(CT5:CU5)    -   CELL CV739 for Totals for CELLS CT & CU; sum column CV for total        hours for all rooms scheduled for sophomore for any/all criteria        scheduled on or within selected date period    -   =SUM(CV5:CV738)    -   SelectPeriod & Any/All Criteria-Level SIM Totals for        Columns—Note: due to size of formulas “C-G”+“H-K” to sum for        each level—the column sum and count from the summed are “copied”        to SelectedPeriod sheet row 4, columns C through J    -   CELL DL5 for fr-C-G represents number of hours for all rooms in        columns C-G scheduled for freshman in SIM for any/all criteria        scheduled on or within selected date period; if “fr-” and “SIM”        and criteria defined on SelectPeriod sheet in cells absolute        cells C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary! C11,D11,E11,F11 and/or G11 returns sum of 3 numbers        from each true cell third position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $C11))*(FIND(“SIM”,Summary!$C11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$C11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$H$9,Summary!$C11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $C11,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $D11))*(FIND(“SIM”,Summary!$D11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$D11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$H$9,Summary!$D11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $D11,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $E11))*(FIND(“SIM”,Summary!$E11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$E11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$H$9,Summary!$E11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<SelectedPeriod!    -   $H$1),MID(Summary!    -   $E11,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $F11))*(FIND(“SIM”,Summary!$F11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$F11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$H$9,Summary!$F11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $F11,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $G11))*(FIND(“SIM”,Summary!$G11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$G11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$H$9,Summary!$G11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!$G11,3,3)*1,0))    -   CELL DM5 for fr-H-K represents number of hours for all rooms in        columns H-K scheduled for freshman in SIM for any/all criteria        scheduled on or within selected date period; if “fr-” and “SIM”        and criteria defined on SelectPeriod sheet in cells absolute        cells C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary!H11,I11,J11, and/or K11 returns sum of 3 numbers from        each true cell third position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $H11))*(FIND(“SIM”,Summary!$H11)*(FIND(SelectedPeriod!    -   $C$9,Summary!$H11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$H$9,Summary!$H11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=Selected Period!    -   $H$1),MID(Summary!    -   $H11,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $I11))*(FIND(“SIM”,Summary!$I11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$I11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I11))*FIND(SelectedPeriod!$E$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$H$9,Summary!$I11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I11,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $J11))*(FIND(“SIM”,Summary!$J11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$J11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$H$9,Summary!$J11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J11,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $K11))*(FIND(“SIM”,Summary!$K11)*(FIND(SelectedPeriod!    -   $C$9,Summary!$K11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$H$9,Summary!$K11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!$K11,3,3)*1,0))    -   CELL DN5 for fr-Total represents number of hours for all rooms        C-G+H-K scheduled for freshman in SIM for any/all criteria        scheduled on or within selected date period; sum cells DL & DM    -   =SUM(DL5:DM5)    -   CELL DL6 for fr-C-G represents number of hours for all rooms in        columns C-G scheduled for freshman in SIM for any/all criteria        scheduled on or within selected date period; if “fr-” and “SIM”        and criteria defined on SelectPeriod sheet in cells absolute        cells C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary!H11,I11,J11 and/or K11 returns sum of 3 numbers from        each true cell third position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $C12))*(FIND(“SIM”,Summary!$C12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$C12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$H$9,Summary!$C12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $C12,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $D12))*(FIND(“SIM”,Summary!$D12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$D12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D12))*FIND(SelectedPeriod!$G$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$H$9,Summary!$D12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $D12,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $E12))*(FIND(“SIM”,Summary!$E12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$E12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$H$9,Summary!$E12)))*Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $E12,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $F12))*(FIND(“SIM”,Summary!$F12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$F12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$H$9,Summary!$F12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $F12,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $G12))*(FIND(“SIM”,Summary!$G12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$G12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G12)*(FIND(SelectedPeriod!$E$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$H$9,Summary!$G12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!$G12,3,3)*1,0))    -   CELL DM6 for fr-H-K represents number of hours for all rooms in        columns H-K scheduled for freshman in SIM for any/all criteria        scheduled on or within selected date period; if “fr-” and “SIM”        and criteria defined on SelectPeriod sheet in cells absolute        cells C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary!H12,I12,J12, and/or K12 returns sum of 3 numbers from        each true cell third position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $H12))*(FIND(“SIM”,Summary!$H12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$H12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$H$9,Summary!$H12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $H12,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $I12))*(FIND(“SIM”,Summary!$I12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$I12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$H$9,Summary!$I12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I12,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $J12))*(FIND(“SIM”,Summary!$J12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$J12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$H$9,Summary!$J12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J12,3,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $K12))*(FIND(“SIM”,Summary!$K12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$K12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$H$9,Summary!$K12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!$K12,3,3)*1,0))    -   CELL DN6 for fr-Total represents number of hours for all rooms        C-G+H-K scheduled for freshman in SIM for any/all criteria        scheduled on or within selected date period; sum cells DL & DM    -   =SUM(DL6:DM6)    -   CELL DN739 Totals for CELLS DL & DM; sum column DN for total        hours for all rooms scheduled for freshman in “SIM” for any/all        criteria scheduled on or within selected date period    -   =SUM(DN5:DN738)    -   CELL DO5 for so-C-G represents number of hours for all rooms in        columns C-G scheduled for sophomore in SIM for any/all criteria        scheduled on or within selected dale period; if “so-” and “SIM”        and criteria defined on SelectPeriod sheet in cells absolute        cells C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary!C11,D11,E11,F11 and/or G11 returns sum of 3 numbers from        each true cell third position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“so-”,Summary!    -   $C11))*(FIND(“SIM”,Summary!$C11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$C11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$H$9,Summary!$C11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $C11,3,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $D11))*(FIND(“SIM”,Summary!$D11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$D11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$H$9,Summary!$D11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $D11,3,3)*1.0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $E11))*(FIND(“SIM”,Summary!$E11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$E11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$H$9,Summary!$E11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $E11,3,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $F11))*(FIND(“SIM”,Summary!$F11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$F11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$H$9,Summary!$F11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $F11,3,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $G11))*(FIND(“SIM”,Summary!$G11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$G11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$H$9,Summary!$G11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!$G11,3,3)*1,0))    -   CELL DP5 for so-H-K represents number of hours for all rooms in        columns H-K scheduled for sophomore in SIM for any/all criteria        scheduled on or within selected date period; if “so-” and “SIM”        and criteria defined on SelectPeriod sheet in cells absolute        cells C9,D9,E9,F9,G9,H9 and on or between dates specified on        SelectPeriod sheet absolute cells F1 and G1 are found in cells        Summary! H11,I11,J11 and/or K11 returns sum of 3 numbers from        each true cell third position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“so-”,Summary!    -   $H11))*(FIND(“SIM”,Summary!$H11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$H11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$H$9,Summary!$H11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $H11,3,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $I11))*(FIND(“SIM”,Summary!$I11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$I11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $I11))*FIND(SelectedPeriod!$G$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$H$9,Summary!$I11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I11,3,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $J11))*(FIND(“SIM”,Summary!$J11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$J11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J11))*(FIND)(SelectedPeriod!$G$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$H$9,Summary!$J11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J11,3,3)*1,0)+IF(ISNUMBER(((FIND)(“so-”,Summary!    -   $K11))*(FIND(“SIM”,Summary!$K11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$K11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$H$9,Summary!$K11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!$K11,3,3)*1,0))    -   CELL DQ5 for so-Total represents number of hours for all rooms        C-G+H-K scheduled for sophomore in SIM for any all criteria        scheduled on or within selected date period; sum cells DO & DP    -   =SUM(DO5:DP5)    -   CELL DQ739 Totals for CELLS DO & DP; sum columns DQ for total        hours for all rooms scheduled for sophomore in “SIM” for any all        criteria scheduled on or within selected date period    -   =SUM(DQ5:DQ738)    -   SelectPeriod & Any/All Criteria-Level Stdnt Totals for        Columns—Note: due to size of formulas “C-G”+“H-K” to sum for        each level—the column sum and count from the summed are “copied”        to SelectedPeriod sheet row 4, columns C through J    -   CELL EG5 for fr-C-G represents number of hours for all rooms in        columns C-G scheduled for freshman for Stdnt for any/all        criteria scheduled on or within selected date period; if “fr-”        and “Stdnt” and criteria defined on SelectPeriod sheet in cells        absolute cells C9,D9,E9,F9,G9,H9 and on or between dates        specified on SelectPeriod sheet absolute cells F1 and G1 are        found in cells Summary!    -   C11,D11,E11,F11 and/or G11 returns sum of 3 numbers from each        true cell tenth position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $C11))*(FIND(“Stdnt”,Summary!$C11)))*FIND(SelectedPeriod!    -   $C$9,Summary!$C11))*FIND(SelectedPeriod!$D$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$H$9,Summary!$C11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $C11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $D11))*(FIND(“Stdnt”,Summary!$D11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$D11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$H$9,Summary!$D11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $D11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $E11))*(FIND(“Stdnt”,Summary!$E11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$E11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$H$9,Summary!$E11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $E11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $F11))*(FIND(“Stdnt”,Summary!$F11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$F11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$H$9,Summary!$F11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $F11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $G11))*(FIND(“Stdnt”,Summary!$G11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$G11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$H$9,Summary!$G11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!$G11,10,3)*1.0))    -   CELL EH5 for fr-H-K represents number of hours for all rooms in        columns H-K scheduled for freshman for Stdnt for any/all        criteria scheduled on or within selected date period; if “fr-”        and “Stdnt” and criteria defined on SelectPeriod sheet in cells        absolute cells C9,D9,E9,F9,G9,H9 and on or between dates        specified on SelectPeriod sheet absolute cells F1 and G1 are        found in cells Summary!H11,I11,J11, and/or K11 returns sum of 3        numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $H11))*(FIND(“Stdnt”,Summary!$H11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$H11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H11)*(FIND(SelectedPeriod!$E$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$H$9,Summary!$H11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $H11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $I11)*(FIND(“Stdnt”,Summary!$I11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$I11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$H$9,Summary!$I11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $J11))*(FIND(“Stdnt”,Summary!$J11))*(FIND(SelectedPeriod!    -   $C$9,Summary!$J11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$H$9,Summary!$J11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $K11))*(FIND(“Stdnt”,Summary!$K11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$K11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$H$9,Summary!$K11))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!$K11,10,3)*1,0))    -   CELL EI5 for fr-Total represents number of hours for all rooms        C-G+H-K scheduled for freshman for “Stdnt” for any/all criteria        scheduled on or within selected date period; sum cells EG & EH    -   =SUM(EG5:EH5)    -   CELL EG6 for fr-C-G represents number of hours for all rooms in        columns C-G scheduled for freshman for Stdnt for any/all        criteria scheduled on or within selected date period: if “fr-”        and “Stdnt” and criteria defined on SelectPeriod sheet in cells        absolute cells C9,D9,E9,F9,G9,H9 and on or between dates        specified on SelectPeriod sheet absolute cells F1 and G1 are        found in cells Summary!C12,D12,E12,F12 and/or G12 returns sum of        3 numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $C12))*(FIND(“Stdnt”,Summary!$C12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$C12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$H$9,Summary!$C12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $C12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $D12))*(FIND(“Stdnt”,Summary!$D12)))*(FIND(Selected Period!    -   $C$9,Summary!$D12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$H$9,Summary!$D12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $D12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $E12))*(FIND(“Stdnt”,Summary!$E12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$E12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$H$9,Summary!$E12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<SelectedPeriod!    -   $H$1),MID(Summary!    -   $E12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $F12))*(FIND(“Stdnt”,Summary!$F12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$F12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$H$9,Summary!$F12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $F12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $G12))*(FIND(“Stdnt”,Summary!$G12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$G12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$H$9,Summary!$G12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!$G12,10,3)*1,0))    -   CELL EH6 for fr-H-K represents number of hours for all rooms in        columns H-K scheduled for freshman for Stdnt for any/all        criteria scheduled on or within selected date period; if “fr-”        and “Stdnt” and criteria defined on SelectPeriod sheet in cells        absolute cells C9,D9,E9,F9,G9,H9 and on or between dates        specified on SelectPeriod sheet absolute cells F1 and G1 are        found in cells Summary!H12,I12,J12, and/or K12 returns sum of 3        numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $H12))*(FIND(“Stdnt”,Summary!$H12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$H12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$H$9,Summary!$H12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $H12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $I12))*(FIND(“Stdnt”,Summary!$I12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$I12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$H$9,Summary!$I12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $J12))*(FIND(“Stdnt”,Summary!$J12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$J12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$H$9,Summary!$J12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $K12))*(FIND(“Stdnt”,Summary!$K12)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$K12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$H$9,Summary!$K12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!$K12,10,3)*1.0))    -   CELL EI6 for fr-Total represents number of hours for all rooms        C-G+H-K scheduled for freshman for “Stdnt” for any/all criteria        scheduled on or within selected date period; sum cells EG & EH    -   =SUM(EG6:EH6)    -   CELL EI739 for Totals for CELLS EG & EH; sum columns EI for        total hours for all rooms scheduled for freshman for “Stdnt” for        any/all criteria scheduled on or within selected date period    -   =SUM(EI5:EI738)    -   CELL EJ5 for so-C-G represents number of hours for all rooms in        columns C-G scheduled for sophomore for Stdnt for any/all        criteria scheduled on or within selected date period; if “so-”        and “Stdnt” and criteria defined on SelectPeriod sheet in cells        absolute cells C9,D9,E9,F9,G9,H9 and on or between dales        specified on SelectPeriod sheet absolute cells F1 and G1 are        found in cells Summary!C11,D11,E11,F11 and/or G11 returns sum of        3 numbers from each true cell tenth position, else 0        -   =SUM(IF(ISNUMBER(((FIND(“so-”,Summary!    -   $C11))*(FIND(“Stdnt”,Summary!$C11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$C11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$H$9,Summary!$C11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $C11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $D11))*(FIND(“Stdnt”,Summary!$D11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$D11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$H$9,Summary!$D11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $D11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $E11))*(FIND(“Stdnt”,Summary!$E11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$E11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$H$9,Summary!$E11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $E11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $F11))*(FIND(“Stdnt”,Summary!$F11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$F11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$H$9,Summary!$F11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $F11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $G11))*(FIND(“Stdnt”,Summary!$G11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$G11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$H$9,Summary!$G11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!$G11,10,3)*1.0))    -   CELL EK5 for so-H-K represents number of hours for all rooms in        columns H-K scheduled for sophomore for Stdnt for any/all        criteria scheduled on or within selected date period; If “so-”        and “Stdnt” and criteria defined on SelectPeriod sheet in cells        absolute cells C9,D9,E9,F9,G9,H9 and on or between dates        specified on SelectPeriod sheet absolute cells F1 and G1 are        found in cells Summary!H11,I11,J11 and or K11 returns sum of 3        numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“so-”,Summary!    -   $H11))*(FIND(“Stdnt”,Summary!$H11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$H11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$H$9,Summary!$H11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $H11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $I11))*(FIND(“Stdnt”,Summary!$I11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$I11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$F$9,Summary!    -   I11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$H$9,Summary!$I11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $J11))*(FIND(“Stdnt”,Summary!$J11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$J11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$H$9,Summary!$J11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $K11))*(FIND(“Stdnt”,Summary!$K11)))*(FIND(SelectedPeriod!    -   $C$9,Summary!$K11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$H$9,Summary!$K11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!$K11,10,3)*1,0))    -   CELL EL5 for so-Total represents number of hours for all rooms        C-G+H-K scheduled for sophomore for “Stdnt” for any/all criteria        scheduled on or within selected date period; sum cells EJ & EK    -   =SUM(EJ5:EK5)    -   CELL EL739 for Totals for CELLS EJ & EK; sum column EL for total        hours for all rooms scheduled for sophomore for “Stdnt” for        any/all criteria scheduled on or within selected date period    -   =SUM(EL5:EL738)    -   SelectPeriod & Any All Criteria-Level Stdnt & SIM Totals for        Columns—Note: due to size of formulas “C-G”+“H-K” to sum for        each level—the column sum and count from the summed are “copied”        to Selected Period sheet row 4, columns C through J    -   CELL FB5 for fr-C-G represents number of hours for all rooms in        columns C-G scheduled for freshman for Stdnt in SIM for any/all        criteria scheduled on or within selected date period; if “fr-”        and “SIM” and “Stdnt” and criteria defined on SelectPeriod sheet        in cells absolute cells C9,D9,E9,F9,G9,H9 and on or between        dates specified on SelectPeriod sheet absolute cells F1 and G1        are found in cells Summary!C11,D11,E11,F11 and/or G11 returns        sum of 3 numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $C11))*(FIND(“SIM”,Summary!$C11))*(FIND(“Stdnt”,Summary!    -   $C11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$H$9,Summary!$C11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $C11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $D11))*(FIND(“SIM”,Summary!$D11))*(FIND(“Stdnt”,Summary!    -   $D11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$H$9,Summary!$D11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $D11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $E11))*(FIND(“SIM”,Summary!$E11))*(FIND(“Stdnt”,Summary!    -   $E11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$H$9,Summary!$E11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $E11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $F11))*(FIND(“SIM”,Summary!$F11))*(FIND(“Stdnt”,Summary!    -   $F11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$H$9,Summary!$F11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $F11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $G11))*(FIND(“SIM”,Summary!$G11))*(FIND(“Stdnt”,Summary!    -   $G11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$H$9,Summary!$G11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!$G11,10,3)*1,0))    -   CELL FC5 for fr-H-K represents number of hours for all rooms in        columns H-K scheduled for freshman for Stdnt in SIM for any/all        criteria scheduled on or within selected date period; if “fr-”        and “SIM” and “Stdnt” and criteria defined on SelectPeriod sheet        in cells absolute cells C9,D9,E9,F9,G9,H9 and on or between        dates specified on SelectPeriod sheet absolute cells F1 and G1        are found in cells Summary!H11,I11,J11, and/or K11 returns sum        of 3 numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $H11))*(FIND(“SIM”,Summary!$H11))*(FIND(“Stdnt”,Summary!    -   $H11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$H$9,Summary!$H11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $H11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $I11))*(FIND(“SIM”,Summary!$I11))*(FIND(“Stdnt”,Summary!    -   $I11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$H$9,Summary!$I11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $J11))*(FIND(“SIM”,Summary!$J11))*(FIND(“Stdnt”,Summary!    -   $J11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$H$9,Summary!$J11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J11,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $K11))*(FIND(“SIM”,Summary!$K11)*(FIND(“Stdnt”,Summary!    -   $K11))))*(FIND(SelectedPeriod!$C$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$H$9,Summary!$K11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!$K11,10,3)*1,0))    -   CELL FD5 for fr-Total represents number of hours for all rooms        C-G+H-K scheduled for freshman for “Stdnt” in SIM for any/all        criteria scheduled on or within selected date period; sum cells        FB & FC    -   =SUM(FB5:FC5)    -   CELL FB6 for fr-C-G represents number of hours for all rooms in        columns C-G scheduled for freshman for Stdnt in SIM for any/all        criteria scheduled on or within selected date period; if “fr-”        and “SIM” and “Stdnt” and criteria defined on SelectPeriod sheet        in cells absolute cells C9,D9,E9,F9,G9,H9 and on or between        dates specified on SelectPeriod sheet absolute cells F1 and G1        are found in cells Summary!C12,D12,E12,F12 and/or G12 returns        sum of 3 numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $C12))*(FIND(“SIM”,Summary!$C12))*(FIND(“Stdnt”,Summary!    -   $C12)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C12))*(FIND(SelectedPeriod!$H$9,Summary!$C12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $C12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $D12))*(FIND(“SIM”,Summary!$D12))*(FIND(“Stdnt”,Summary!    -   $D12)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D12))*(FIND(SelectedPeriod!$H$9,Summary!$D12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $D12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $E12))*(FIND(“SIM”,Summary!$E12))*(FIND(“Stdnt”,Summary!    -   $E12)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E12))*(FIND(SelectedPeriod!$H$9,Summary!$E12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $E12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $F12))*(FIND(“SIM”,Summary!$F12))*(FIND(“Stdnt”,Summary!    -   $F12)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F12))*(FIND(SelectedPeriod!$H$9,Summary!$F12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $F12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $G12))*(FIND(“SIM”,Summary!$G12))*(FIND(“Stdnt”,Summary!    -   $G12)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G12))*(FIND(SelectedPeriod!$H$9,Summary!$G12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1),MID(Summary!$G12,10,3)*1.0))    -   CELL FC6 for fr-H-K represents number of hours for all rooms in        columns H-K scheduled for freshman for Stdnt in SIM for any/all        criteria scheduled on or within selected date period; if “fr-”        and “SIM” and “Stdnt” and criteria defined on SelectPeriod sheet        in cells absolute cells C9,D9,E9,F9,G9,H9 and on or between        dates specified on SelectPeriod sheet absolute cells F1 and G1        are found in cells Summary!H12,I12,J12, and/or K12 returns sum        of 3 numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $H12))*(FIND(“SIM”,Summary!$H12))*(FIND(“Stdnt”,Summary!    -   $H12)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H12))*(FIND(SelectedPeriod!$H$9,Summary!$H12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $H12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $I12))*(FIND(“SIM”,Summary!$I12))*(FIND(“Stdnt”,Summary!    -   $I12)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $I12))*(FIND(SelectedPeriod!$H$9,Summary!$I12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $J12))*(FIND(“SIM”,Summary!$J12))*(FIND(“Stdnt”,Summary!    -   $J12)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $J12))*(FIND(SelectedPeriod!$H$9,Summary!$J12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J12,10,3)*1,0)+IF(ISNUMBER(((FIND(“fr-”,Summary!    -   $K12))*(FIND(“SIM”,Summary!$K12)*(FIND(“Stdnt”,Summary!    -   $K12)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K12))*(FIND(SelectedPeriod!$H$9,Summary!$K12)))*(Summary!    -   $A12>=SelectedPeriod!$F$1)*(Summary!$A12<=SelectedPeriod!    -   $H$1), MID(Summary!$K12,10,3)*1,0))    -   CELL FD6 for fr-Total represents number of hours for all rooms        C-G+H-K scheduled for freshman for “Stdnt” in SIM for any/all        criteria scheduled on or within selected date period; sum cells        FB & FC    -   =SUM(FB6:FC6)    -   CELL FD739 for Totals for CELLS FB & FC; sum column FD for total        hours for all rooms scheduled for freshman for “Stdnt” in SIM        for any/all criteria scheduled on or within selected date period    -   =SUM(FD5:FD738)    -   CELL FE5 for so-C-G represents number of hours for all rooms in        columns C-G scheduled for sophomore for Stdnt in SIM for any/all        criteria scheduled on or within selected date period; if “so-”        and “SIM” and “Stdnt” and criteria defined on SelectPeriod sheet        in cells absolute cells C9,D9,E9,F9,G9,H9 and on or between        dates specified on SelectPeriod sheet absolute cells F1 and G1        are found in cells Summary!C11,D11,E11,F11 and/or G11 returns        sum of 3 numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“so-”,Summary!    -   $C11))*(FIND(“SIM”,Summary!$C11))*(FIND(“Stdnt”,Summary!    -   $C11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $C11))*(FIND(SelectedPeriod!$H$9,Summary!$C11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $C11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $D11))*(FIND(“SIM”,Summary!$D11))*(FIND(“Stdnt”,Summary!    -   $D11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $D11))*(FIND(SelectedPeriod!$H$9,Summary!$D11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $D11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $E11))*(FIND(“SIM”,Summary!$E11))*(FIND(“Stdnt”,Summary!    -   $E11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $E11))*(FIND(SelectedPeriod!$H$9,Summary!$E11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $E11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $F11))*(FIND(“SIM”,Summary!$F11))*(FIND(“Stdnt”,Summary!    -   $F11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $F11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $F11))*(SelectedPeriod!$H$9,Summary!$F11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!    -   $F11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $G11))*(FIND(“SIM”,Summary!$G11))*(FIND(“Stdnt”,Summary!    -   $G11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $G11))*(FIND(SelectedPeriod!$H$9,Summary!$G11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1),MID(Summary!$G11,10,3)*1,0))    -   CELL FF5 for so-H-K represents number of hours for all rooms in        columns H-K scheduled for sophomore for Stdnt in SIM for any/all        criteria scheduled on or within selected date period; if “so-”        and “SIM” and “Stdnt” and criteria defined on SelectPeriod sheet        in cells absolute cells C9,D9,E9,F9,G9,H9 and on or between        dates specified on SelectPeriod sheet absolute cells F1 and G1        are found in cells Summary!H11,I11,J11, and/or K11 returns sum        of 3 numbers from each true cell tenth position, else 0    -   =SUM(IF(ISNUMBER(((FIND(“so-”,Summary!    -   $H11))*(FIND(“SIM”,Summary!$H11))*(FIND(“Stdnt”,Summary!    -   $H11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $H11))*(FIND(SelectedPeriod!$H$9,Summary!$H11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $H11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $I11))*(FIND(“SIM”,Summary!$I11))*(FIND(“Stdnt”,Summary!    -   $I11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $I11))*(FIND(SelectedPeriod!$H$9,Summary!$I11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $I11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $J11))*(FIND(“SIM”,Summary!$J11))*(FIND(“Stdnt”,Summary!    -   $J11)))*(FIND(SelectedPeriod!$C$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $J11))*(FIND(SelectedPeriod!$H$9,Summary!$J11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!    -   $J11,10,3)*1,0)+IF(ISNUMBER(((FIND(“so-”,Summary!    -   $K11))*(FIND(“SIM”,Summary!$K11)*(FIND(“Stdnt”,Summary!    -   $K11))*(FIND(SelectedPeriod!$C$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$D$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$E$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$F$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$G$9,Summary!    -   $K11))*(FIND(SelectedPeriod!$H$9,Summary!$K11)))*(Summary!    -   $A11>=SelectedPeriod!$F$1)*(Summary!$A11<=SelectedPeriod!    -   $H$1), MID(Summary!$K11,10,3)*1,0))    -   CELL FG5 for so-Total represents number of hours for all rooms        C-G+H-K scheduled for sophomore for “Stdnt” in SIM for any/all        criteria scheduled on or within selected date period; sum cells        FE & FF    -   =SUM(FE5:FF5)    -   CELL FG739 for Totals for CELLS FE & FF; sum column FG for total        hours for all rooms scheduled for sophomore for “Stdnt” in SIM        for any/all criteria scheduled on or within selected date period    -   =SUM(FG5:FG738)

Although the invention has been described with particularity above, withreference to a first embodiment and to particulars and specifics, theinvention is only to be limited insofar as is set forth in theaccompanying claims:

The invention claimed is:
 1. A computer containing a system forautomated processing for scheduling, managing and reporting usage of twoor more training facilities by two or more grade levels “xl” ofinstruction, wherein xl is a level variable indicating grade level,comprising: a processor, the processor being configured to perform thesteps of: entering on a spreadsheet on said computer single-cell,multiple-criteria data with on-screen instructions, followed bysingle-cell student level classification, retrieval and totaling on aTally Sheet using the formula=IF(ISNUMBER(FIND(“xl-”,Summary!$J10))*(FIND(“SIM-”,Summary!$J10)),MID(Summary!$J10,4,3),0),and a formula (CW5=FALSE,VALUE(0); obtaining automatically summed totalsby room, student level, and simulation classification, on a SummarySheet utilizing formulas =Tally!$C178&″Hrs: ″&Tally!$J178, and=SUM(Tally!K5:K175,Tally!Y5:Y175,Tally!AM5:AM175,Tally!BA5:BA175,Tally!BO5:BO175,Tally!CC5:CC175,Tally!CQ5:CQ175,Tally!DE5:DE175,Tally!DS5:DS175);obtaining automatically summed totals by student level, and simulationclassification on individualized student level sheets utilizing formula=SUM(Tally!K5:K175,Tally!Y5:Y175,Tally!AM5:AM175,Tally!BA5:BA175,Tally!BO5:BO175,Tally!CC5:CC175,Tally!CQ5:CQ175,Tally!DE5:DE175,Tally!DS5:DS175);and copying the structure of the Summary Sheet to the student levelsheets by formula, =(Summary!A10), so that when the Summary sheet isupdated all related sheets are updated, followed by rendering saidSummary Sheet as output data in customized cells as outputs to a user,and further wherein said user manually applies at least one color to atleast one cell.
 2. A computer containing a system for automatedprocessing for scheduling, managing and reporting usage of two or moretraining facilities by two or more grade levels “xl” of instruction,wherein xl is a level variable indicating grade level, with two or moreclassifications of instruction defining a student experience and hoursincluding user defined multi-criteria queries, comprising: a processor,the processor being configured to perform the steps of: entering datainto a Summary spreadsheet on said at least one computer usingsingle-cell, multiple-criteria data entry, and manual color coding bystudent level (utilizing paint brush) with color coding manuallyassigned as pale yellow—freshman; blue sophomore; orange—junior;purple—senior; pink—second degree; grey—graduate level and with codesselected from the group consisting of a student experience by gradelevel, and a student simulation or non-simulation experience by gradelevel, or any classification defined by the data user; implementingreporting using formulas selected from the group consisting of: forTally Sheet formula=IF(ISNUMBER(FIND(“xl-”,Summary!$J10)),MID(Summary!$J10,4,3),0), andformula =IF(U5=FALSE,VALUE(0),VALUE(U5));  for Tally SIM formula=IF(ISNUMBER((FIND(“xl-”,Summary!$C158))*(FIND(“SIM”,Summary!$C158))),MID(Summary!$C158,10,3),0),and formula =IF(C107=FALSE,VALUE(0),VALUE(C107)); for Tally Stdntformula=IF(ISNUMBER((FIND(“xl-”,Summary!$C158))*(FIND(“Stdnt”,Summary!$C158))),MID(Summary!$C158,10,3),0),and formula =IF(C152=FALSE,VALUE(0),VALUE(C152)); for Tally Stdnt SIMformula=IF(ISNUMBER((FIND(“xl-”,Summary!$C11))*(FIND(“SIM”,Summary!$C11))*(FIND(“Stdnt”,Summary!$C11))),MID(Summary!$C11,10,3),0),and =IF(C5=FALSE,VALUE(0),VALUE(C5)); Tally Open Query formula=IF(ISNUMBER((FIND(Summary!$C$9,Summary!$C11))*(FIND(Summary!$D$9,Summary!$C11))*(FIND(Summary!$E$9,Summary!$C11))*(FIND(Summary!$F$9,Summary!$C11))*(FIND(Summary!$G$9,Summary!$C11))*(FIND(Summary!$H$9,Summary!$C11))),MID(Summary!$C11,10,3),0),and formula =IF(C5=FALSE,VALUE(0),VALUE(C5)); and generating the outputof the spreadsheet to a user by generating: A) automatically summedtotals by room, student level, simulation and non-simulationclassification, a student experience by student level, and a studentsimulation experience by level utilizing formulas =Tally!$C178&″Hrs:″&Tally!$J178, and=SUM(Tally!K5:K175,Tally!Y5:Y175,Tally!AM5:AM175,Tally!BA5:BA175,Tally!BO5:BO175,Tally!CC5:CC175,Tally!CQ5:CQ175,Tally!DE5:DE175,Tally!DS5:DS175);and B) automatically summed totals by student level, simulation andnon-simulation classification, a student experience by student level,and a student simulation experience by level utilizing the formula=SUM(Tally!K5:K175,Tally!Y5:Y175,Tally!AM5:AM175,Tally!BA5:BA175,Tally!BO5:BO175,Tally!CC5:CC175,Tally!CQ5:CQ175,Tally!DE5:DE175,Tally!DS5:DS175);copying the structure of the Summary Sheet to the student level sheetsby formula, =(Summary!A10), wherein as the Summary sheet is updated allrelated sheets are updated.